?
Solved

Export Access 2007 Table to CSV

Posted on 2011-03-14
3
Medium Priority
?
417 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 120

Accepted Solution

by:
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


0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

762 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