Export Access 2007 Table to CSV

Posted on 2011-03-14
Medium Priority
Last Modified: 2012-05-11
I'm working on a small app in access 2007....  I need to export records from a table to a csv, but without the double quotes around the strings...   can anyone give me an idea of how to do this??

Question by:rhcellxion

Expert Comment

ID: 35134602
Right click on the table
text file
select file name and say ok
text qualifier {none}

follow the rest of the process for export


Author Comment

ID: 35134661
thanks sshah....  is there a way to do this in a macro or vba so the user can do it by pressing a button in the app without all the extra steps?

thanks again.
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 1000 total points
ID: 35134712
you have to create an export specification first

right click on the table
select export > Text file
click on Browse and locate the destination folder
(you can accept the proposed name or change it)
click Save, then click OK

1.right click on the table
2.select export > Text file
   click on Browse and locate the destination folder
3. (you can accept the proposed name or change it)
click Save, then click OK
4. In the export text wizard select the type (Delim Fixed) width
5. Follow the wizard, before clicking on Finish
     5a .Click Advanced
       b. select {none} for Text qualifier
6. In the Export Specification dialog box Field Information List, correct any descrepancies

7. click save as, give the specification a name <-- this is the specification name that you will use in the command line below

DoCmd.TransferText acExportDelim, "ExportSpecName", "TableName", "C:\myCsv.csv", True


Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question