Need Transfer/Normalize after import

[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

 

[Jeanette Cunningham]

Warren,
have a look at

November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
from http://www.accessmvp.com/DJSteele/SmartAccess.html


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Warren]

The "Smart Access" link does not work.

Warren,
have a look at

November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
from http://www.accessmvp.com/DJSteele/SmartAccess.html


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Douglas J. Steele]

Try again. It works fine for me.