Advice Needed (1 Viewer)

[Superock]

Hi all,

I am building a dB where I will need to export to excel, then send the spreadsheet to a client who may or may not make changes to the data and/or add completely new data. The spreadsheet will then be sent back to me to be imported back into the database.

I know for changes to the spreadsheet I will have to do a Update query.
I know for new additions to the spreadsheet I will have to do an Append query.

What I am not to sure about is which would be the best method to use to get the data into the dB and how?

1. Linking the excel spreadsheet.
2. Importing the spreadsheet into a dummy table.

 

[Birdy]

I have done this before and the best way that I have found was to import the spreadsheet into a temporary table and then update / append the information. You may also want to think about a delete function too as the client may wish to remove current records (unless history is required).