Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Export Access 2007 Table to CSV

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
rhcellxion
Asked:
rhcellxion
1 Solution
 
sshah254Commented:
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
 
rhcellxionAuthor Commented:
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
 
Rey Obrero (Capricorn1)Commented:
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now