StaRKeY
starkey at wanadoo.nl
Wed Oct 12 16:39:31 CDT 2005
JOHN, I recall having had the same challenge and if I remember right it had something to do with the delimiter if you use the transfertext method! Try changing the ; in a , or the other way around and see if it works that way...or another delimitier but I am almost certain the solution can be found here. If the solution would be changing the csv file format though and your client does not want this I would suggest to use a simple importtemplate.... What's wrong with that? Good luck! Eric Starkenburg Sr Software Developer Dutch: www.o-solutions.nl Global: www.sogeti.nl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, October 11, 2005 11: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 --- avast! Antivirus: Uitgaande bericht is niet besmet. Virus Gegevensbestand (VPS): 0541-1, 12-10-2005 Getest op: 12-10-2005 23:39:34 avast! auteursrecht (c) 1988-2005 ALWIL Software. http://www.avast.com