M marrett Registered User. Local time Today, 17:24 Joined Sep 8, 2000 Messages 43 Oct 15, 2002 #1 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: Oct 15, 2002
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
ghudson Registered User. Local time Today, 12:24 Joined Jun 8, 2002 Messages 6,194 Oct 15, 2002 #2 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
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
M marrett Registered User. Local time Today, 17:24 Joined Sep 8, 2000 Messages 43 Oct 15, 2002 #3 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.
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.