Create an excel file from and txt file from VBA

marrett

Registered User.
Local time
Today, 11:21
Joined
Sep 8, 2000
Messages
43
I need to be able to do the following using access VBA:

1. Open excel

2. Import a text file

3. Save the file

Any help would be appriecated.


Thanks,
Maria
 
Last edited:
Why don't you use the TransferSpreadsheet Method to transfer the data from Access to an Excel workbook?

Check the help files for the TransferSpreadsheet Method for the options and an example.

HTH
 
Text file is not in access

The text file in not in access. For some reason When I import directly in to access all the information goes into one field. When I import into excel it goes into the proper fields.
 

Users who are viewing this thread

Back
Top Bottom