Importing Excel Sheet into a table

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel 2010 table into Access 2010 - not listed as range 1
Importing data from excel spreadsheets 11
Importing hyperlinks 2
Importing Data with Update Query 1
How to export table from outlook into ms access table? 0
Help in Importing from EXcel 4
Access import from Excel - Append & Update simultaneously 1
Importing into a table 1

Top