[AccessD] CSV with no header

John Colby jwcolby at ColbyConsulting.com
Mon Oct 10 20:40:55 CDT 2005


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





More information about the AccessD mailing list