importing Excel files using VBA code

C

Craig

I have a line of code which imports .csv (comma delimited)
files that looks like the following:

DoCmd.TransferText acImportDelim, "SAP Chemical Import
Specification", "SAP Chemical_cleanse", _
"c:\temp\" & path, False

it imports the .csv file into SAP Chemical_cleanse using
the SAP Chemical Import Spec. again, this is for
importing a .csv file. how would I change this for
importing a .xls (MS Excel) file? please e-mail if anyone
has the answer. Thank you.
 

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

importing data 0
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 2
Access is dropping rows on import 1
need help with syntax for docmd.transfertext, ontimer event 5
import from excel by code 0
Import mutiple name text files into Access 2003 1
3625 error 1
Import csv file to Access 2003 table 2

Top