how to import excel to access

[cynthia]

Im trying to import an excel spreadsheet that contains several sheets of
information into a access database that is in place. Any ideas of how to
start the process? Please let me know all information is appreciated. Thank
you

 

[Ken Snell \(MVP\)]

Take a look at the TransferSpreadsheet method (macro or VBA code) as a
starting point. This will import one spreadsheet from one file, and you can
specify the name of the spreadsheet to be imported. Usually best to import
to an empty table, then use an append query to copy the data into your
permanent table.

After you've taken a look at it (help file), post back with more specific
details and we can assist you in setting it up.