Importing from an excel file

[paresh]

I am new to access and want to perform the following activity.
1. Read an excel sheet
2. dump the data from the sheet in a temp table
3. based on the data in the temp table identify if it is new/ updated and
then take similar actions on a set of tables accordingly.

all this is pretty simple using sybase ( bcp , stored proc , temp tables
etc..) but I am not sure as to how to implement this in access. can somebody
help me to figure it out?

 

[dymondjack]

Docmd.TransferSpreadsheet

try that

--
Jack Leach
www.tristatemachine.com

- "A designer knows he has reached perfection not when there is nothing left
to add, but when there is nothing left to take away." - Antoine De Saint
Exupery