[AccessD] CSV with no header

Jim Moss jim.moss at jlmoss.net
Tue Oct 11 10:46:24 CDT 2005


If I had commas within strings, then I would select another delimiter like
a |. I think that you can set that up in a specification.


> 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
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>





More information about the AccessD mailing list