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 ...
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);
INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);