Re: [MS_AccessPros] Exporting data to a csv file

 

Ray - FYI

When you import start up the import dialog box and click on Options. That will give you a bunch of things like Import/Export specs; Menus; relationships; etc.

I never understood why MS hides those options by default.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@yahoo.com> wrote :

hi Ray,

The tables that store import/export specs are:

MsysIMEXspecs
MsysIMEXcolumns

import those into another database. You will need to display System Objects in the Navigation Pane to see them.

have an awesome day,
crystal

Unicode Character Map -- free tool in Access
http://msaccessgurus.com/tool/UnicodeCharMap.htm

On 11/19/2018 9:19 AM, rayfrew@gmail.com [MS_Access_Professionals] wrote:

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: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___