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
 
Back
Top