Charlotte Foust
cfoust at infostatsystems.com
Tue Oct 11 18:36:58 CDT 2005
I would interpret it as comma delimited text with quotes around strings and none around numbers. CSV, is specifically comma-delimited, so you have to use quotes around text to handle possible interior commas. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Tuesday, October 11, 2005 4:12 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] CSV with no header 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