Need Transfer/Normalize after import

  • Thread starter Thread starter Warren
  • Start date Start date
W

Warren

I have successfully imported a data list from an excel spreadsheet into a
temporary Access table. Now I want to transfer the data from that temp table
to existing access tables but don't know where to start or the best way to do
it.

Can somebody refer me to some websites with example procedures. I know I'll
need to use SQL but am not sure about macros.

I want to setup a procedure that transfers from the temp table to the
permanent table(s) and need to be able to use it again and again as the data
will continue to be generated in excel. (For now, I'm okay with manually
importing from excel to the temp Access table.) Each time I execute this
procedure, it will need to append data to existing data residing in the
permanent tables. Also, I'll be concatenating field values from more that
two fields in the temp table to one field in the permanent table.

Thanks for any direction! -Warren
 
Back
Top