Benjaminvh
Registered User.
- Local time
- Today, 18:42
- Joined
- Mar 11, 2009
- Messages
- 17
Hi all
I want to transfer all the records from an access table into a text/csv file. Im using the following code, but get error 424: object required:
DoCmd.TransferText acExportDelim, "Exposure Export Specification", "TEMP_KN_DATA", "C:\Exposure Tool 2009\Exposure.csv"
Any ideas?
In addition, what I really need is to export many tables to the same text file, in other words 'append' them to the text file.
That is the first task. Then, the second:
I need a way of taking the final text file and importing it into an access table IN PARTS (there are too many records in the final csv file to import at once into access). Every now and again, the table needs to be grouped by some fields (which will vary by user input) to reduce the number of records, and then the appending from the csv file can continue, then grouped and so on until the entire csv file has been imported.
Help with either of these would be awesome, although task 1 is more pressing.
THANKS GUYS
I want to transfer all the records from an access table into a text/csv file. Im using the following code, but get error 424: object required:
DoCmd.TransferText acExportDelim, "Exposure Export Specification", "TEMP_KN_DATA", "C:\Exposure Tool 2009\Exposure.csv"
Any ideas?
In addition, what I really need is to export many tables to the same text file, in other words 'append' them to the text file.
That is the first task. Then, the second:
I need a way of taking the final text file and importing it into an access table IN PARTS (there are too many records in the final csv file to import at once into access). Every now and again, the table needs to be grouped by some fields (which will vary by user input) to reduce the number of records, and then the appending from the csv file can continue, then grouped and so on until the entire csv file has been imported.
Help with either of these would be awesome, although task 1 is more pressing.
THANKS GUYS
