[AccessD] CSV with no header

John,

To my understanding the "rules" stated that csv is comma separated fields
with quotes enclosing text strings, nothing enclosing numeric strings.

Jim



> In the end, I don't get to choose.  This is a government export for PlanD
> of
> the Medicare system (or something like that).  The gov says "these fields,
> in this format".  The only problem is that they simply say "csv with no
> header".  What does that mean exactly?
>
> 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 Stuart
> McLachlan
> Sent: Tuesday, October 11, 2005 5:36 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] CSV with no header
>
>
> On 11 Oct 2005 at 10:46, Jim Moss wrote:
>
>> 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.
>>
>>
>
>
> In the Access Import/ExportText wizards you can specify any delimiter you
> like and also specify whether to quote strings.  One problem is when
> strings themselves contain quotes :-(
>
>
> I prefer to use Tab delimited files.  That way fields can contain
> commas,single/double quotes etc.  Tabs are a widely accepted
> "standard"delimiter, you can specift Tab delimited as a Save format in
> Excel and can also select Tab as the delimiter in ImportText/ExportText
> specifications in Access.  If you are building your own file with Print#,
> it's easy to throw in a Chr$(9) and not have to worry about what
> characters
> are in the strings.
>
>
>
>
>
>
>
> --
> Stuart
>
>
> --
> 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
>