Solved

Export Access 2007 Table to CSV

Posted on 2011-03-14
3
384 Views
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??

thanks
randy
0
Comment
Question by:rhcellxion
3 Comments
 
LVL 9

Expert Comment

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

follow the rest of the process for export

Ss
0
 

Author Comment

by:rhcellxion
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.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 250 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


0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now