Import Errors

C

Craig

I am trying to import an Excel spreadsheet with 5 columns
into Access. I have the following line in my code:

DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel97, "CSIS NAT_cleanse", "c:\temp\" &
path, False

for some reason, this table is not mapping correctly.

CSIS NAT_cleanse is the table name in Access
c:\temp\... is the name of the path of the file that must
be imported

just wondering what could be my problem

thank you

craig madrin
(e-mail address removed)
 
J

Joe Fallon

I use this all the time:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
strTableName, strLocalDir & strLocalFileName, True

Try it with short file names, and short paths and no spaces in the table
name.
Also try: Excel8
 

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 ranges - clarify 12
Import Excel Data using TransferSpreadsheet command 4
VBA for Access, import Excell files into Access tables 7
VBA for Access, import Excell files into Access tables 5
Import Excel sheets to Access 2
Transfer Spreadsheet; Import Only UsedRange 2
TransferSpreadsheet problem 1
Assigning a primary key after import using VBA 2

Top