I have an access DB with a table "test". I have 4 Number fields. Using a spreadsheet with 4 columns of numbers, how can I:
1) Connect to the database
2) Select my "test" table
3) Run an INSERT INTO query on the db using the values in the columns of the excel spreadsheet WHEN the user hits Crtl-S (Save).
4) Disable saving a hardcopy (The spreadsheet will be a template that should never be hardcopied, I only want the data cells to be saved in the DB)
Thanks
I am using Excel 2010
1) Connect to the database
2) Select my "test" table
3) Run an INSERT INTO query on the db using the values in the columns of the excel spreadsheet WHEN the user hits Crtl-S (Save).
4) Disable saving a hardcopy (The spreadsheet will be a template that should never be hardcopied, I only want the data cells to be saved in the DB)
Thanks
I am using Excel 2010