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 ...
without overwriting over values in the cel
What does this mean?
Can you give a specific sample data and expected result?
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);peiyezhu Can I use SQL within an Excel spreadsheet? I've never used it before.