Problem with importing excel file to access

L

Lis

Hello,
I am using transferspreadsheet action to import an
excel file to Access. The code which I am using is as
follows.

DoCmd.TransferSpreadsheet
acImport,acSpreadsheetTypeExcel9, c, F, Yes

This code importing the file to Access. But the problem is
I am not getting the fieldnames.Instead of fieldnames like
Item, description, Price etc.... I am getting F1, F2, F3
etc...

When I create macro, this works fine. But I have to use
the code to import the file.
any help, It is really appreciated.
 
K

Ken Snell

Change Yes to True (the argument that tells ACCESS to use field names from
first row).
 

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

Access 2003 versus Access 2007 Excel Import 0
Extract embedded excel file from word document 0
import data from excel 1
Merging from an Excel file with graphics 1
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
CSV Import Error 2
Importing from a closed workbook 3

Top