PC Review


Reply
Thread Tools Rate Thread

Exporting table contents

 
 
=?Utf-8?B?T3JsYW5kbyBNb3JhbGVz?=
Guest
Posts: n/a
 
      20th Feb 2007
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
--
Orlando Morales
 
Reply With Quote
 
 
 
 
=?Utf-8?B?RGFtaWFuIFM=?=
Guest
Posts: n/a
 
      20th Feb 2007
Hi Orlando,

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

Damian.

"Orlando Morales" wrote:

> 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
> --
> Orlando Morales

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting contents of range to Access...HELP! WhytheQ Microsoft Excel Programming 0 14th Aug 2006 10:34 PM
Exporting Database Properties Contents =?Utf-8?B?Q2FybFNwcmFrZQ==?= Microsoft Access 2 28th Jun 2005 01:01 PM
exporting outlook contents to a new computer =?Utf-8?B?RU1M?= Microsoft Outlook Discussion 1 17th Jan 2005 05:18 PM
exporting outlook contents to a new computer =?Utf-8?B?ZW1sb3ZlbWFu?= Microsoft Outlook Discussion 2 13th Jan 2005 09:44 PM
Exporting Listbox contents to Excel Jerome Carter Microsoft Access External Data 0 30th Jun 2004 06:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:43 PM.