Import an Excel file

J

Jone

Hi everyone

I have a Microsoft Excel 2007 file and I have three columns (1=Code 2=First
3=Last) that I want to import to my table called Names where I have the
same fields like the Excel file in my Access 2007 database, what code do I
write to import this Excel file?
 
J

Jeanette Cunningham

Jone,
use transfer spreadsheet.
DoCmd.TransferSpreadsheet

Look up vba help for transfer spreadsheet to see how to set up the arguments
and tell it what to import.


Jeanette Cunningham -- Melbourne Victoria Australia
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Excel check field names Please Help 1
Excel Import Specification 1
Import 4 Different Excel Files from One Folder 0
Open Fixed Width Text File from Access 2
TransferSpreadsheet question 4
Import same Excel ranges from many workbooks 3
How do I import an Excel file with MULTIPLE WORKSHEETS into Access 8

Top