Import an Excel file

  • Thread starter Thread starter Jone
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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
Excel Import Specification 1
Import Excel check field names Please Help 1
Exporting to Excel and importing back (Access2007) - Determing Ran 2
Importing data problems from Excel 2
Save Excel File as 2003 Programmatically 2
Excel Import XML into Excel 0
Import 4 Different Excel Files from One Folder 0

Back
Top