Exporting table contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm trying to export a table content using DoCmd.TransferText method, the
problem is that it exports all content delimited with "". I need to do it
without this ''', I used the export wizard that comes when you select the
table and do the right click, it exports without the "". Any suggestions
 
Hi Orlando,

By default, Access exports using quote-delimited text. Have you tried using
acExportFixed instead?

Damian.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Query - Want count of records 5
VBA Export with date/time stamp 5
exporting multiple tables 1
TransferText using wrong format 0
TransferText - Export Table to Text File and Include Column Names 6
Export fixed width file from Access 2003 2
export table contents to .txt 2
Exporting Table to Text file including Fielnames 2

Back
Top