Forum Discussion
Excel (or Access): Save cell values to table
Hi, I am looking for a way to have values in cells automatically saved to a table. I have a spreadsheet where I enter a name and assign a number based on a formula. I need to save these two cells to a table without overwriting over values in the cell. I also need to save on demand, since the number is adjusted before it needs to be saved. Does anyone know of a script that can do what I'm describing? I'm open to moving this to Access if there is an easier way to do it there.
The values to be saved will also be in the same area every time, and the table will get continuously longer as I add more names/value sets. Thanks in advance!
- MS-Access would be best choice for this case. Just design a table and a data entry form. Use that table as data source of the data entry form. MS-Access form will save data to table automatically and continuous.
- without overwriting over values in the cel
What does this mean?
Can you give a specific sample data and expected result?peiyezhuI mean that I want the table that values are saved to to keep expanding. I.e., if the table is filled up to 15 rows, clicking this save button will add another row and not overwrite the previous cells.
- sql:
INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);
