Importing Excel Sheet into a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I dont have much experience at importing spreadsheets into Access and am
looking to take a named sheet (Data) on a spreadsheet and import it to a
temporary table in Access and then append this table to my main table. Once
thats done then delete the Temp table. How is this possible to do?

Please help :-)

Thanks, Jez
 
To import the table
File/Get External Data/Import

Create an append query to append the records to the main table

Delete the temp table

All this can be put into a Access macro
Instead of importing to a table I would link to the Excel spreadsheet using
File/Get External Data/Link tables
 
Back
Top