[AccessD] CSV with no header

MartyConnelly martyconnelly at shaw.ca
Thu Oct 13 15:08:23 CDT 2005


Maybe this will help very bottom of article
http://support.microsoft.com/kb/247412/EN-US/


John Colby wrote:

>I am trying that but it ends up bracketing the fields with ".  I suppose
>that if a comma is embedded in the string then the "" is required to specify
>that the , is internal to the string and not a delimiter.  Is the "" part of
>the csv spec?
>
>John W. Colby
>www.ColbyConsulting.com 
>
>Contribute your unused CPU cycles to a good cause:
>http://folding.stanford.edu/
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Moss
>Sent: Monday, October 10, 2005 4:26 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] CSV with no header
>
>
>If you use docmd.TransferText you can set the parameter after filename to
>false.
>
>
>  
>
>>Does anyone know a simple way to do a CSV without the header?  And 
>>yea, I can do the export, open the file and delete the first line.
>>
>>Other than that...?
>>
>>John W. Colby
>>www.ColbyConsulting.com
>>
>>Contribute your unused CPU cycles to a good cause: 
>>http://folding.stanford.edu/
>>
>>
>>--
>>AccessD mailing list
>>AccessD at databaseadvisors.com 
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>    
>>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list