Hi Ray,
There are two system tables that store this information:
MSysIMEXSpecs
MSysIMEXColumns
If you go into the options in Access Current Database - Navigation Options, you can choose to see the system objects. Then if you import objects from another database, these system tables will be visible.
Sent: Monday, November 19, 2018 9:19 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Exporting data to a csv file
Hi Everyone
I needed to export the contents of a table to a csv file. Not too difficult once I found DoCmd.TransferText. However, when I first used TransferText it created double quotes around each text field - which caused problems to the receiving software. I then found out that you can create an output specification that removes the double quotes and that spec is saved somewhere in the database (exactly where is really my question).
When I created another copy of the database for testing purposes, I found that the csv spec had not been copied across. I had to start from scratch again and create the csv spec manually using :
Select table, Export to Text file, change the type from .txt to .csv, OK, click Advanced button.
In the Export Specification pop up window, change the Text Qualifier to {none}.
Choose Save As... to save the specification format.
The vba code I'm using is
DoCmd.TransferText acExportDelim, "CSV_Specification", "tempXeroMthlyTransfer", strOutputFilename, 1
My question is where is my manual CSV_Specification stored and can I easily copy it other databases?
Many thanks for your ideas.
Best regards
Ray
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar