Forum Discussion
nicktherushfan
Jan 13, 2024Copper Contributor
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 ...
peiyezhu
Jan 14, 2024Bronze Contributor
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?
nicktherushfan
Jan 14, 2024Copper Contributor
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.
- peiyezhuJan 14, 2024Bronze Contributorsql:
INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);- nicktherushfanJan 15, 2024Copper Contributor
peiyezhu Can I use SQL within an Excel spreadsheet? I've never used it before.
- peiyezhuJan 15, 2024Bronze Contributor