David Emerson
newsgrps at dalyn.co.nz
Sat Oct 11 21:21:47 CDT 2008
You may have a good point there. I will do some testing at this end as well. Thanks David At 10/12/2008, you wrote: >I understand that, but it still gives you the appropriate format for a CSV. >I may have some code from my Master's Thesis Project that will handle this. >I will look for it when I get home. >Also, I think that you could use DoCmd.TransferText or >docmd.TransferSpreadsheet to invoke this functionality in code. I will try >that out and check how different number of fields will affect it. >Regards, >Steve Goodhall, PMP >248-505-5204 mobile > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson >Sent: Saturday, October 11, 2008 3:24 PM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Exporting/Importing CSV files > >This would work if I was using the menus to export, import, but >everything is done by code to handle rows with different numbers of >fields in them. I think Drew's (final) solution may be the one to use. > >Thanks all for your input > >David > >At 10/11/2008, you wrote: > >I checked this by exporting and importing a file using Menu, File, Export > >and Menu, File, Get External Data. I start with a table that looks like > >this: > >Table1 > >ID T1 T2 > >1 T11 T21 > >2 T2,2 T22 > >3 T32 T3,2 > >4 T4,1 T4,2 > >5 T4"1 T5'2 > > > >I export it to a CSV format which looks like this: > >"ID","T1","T2" > >1,"T11","T21" > >2,"T2,2","T22" > >3,"T32","T3,2" > >4,"T4,1","T4,2" > >5,"T4""1","T5'2" > >I import it and I get: > >Table1A > >ID T1 T2 > >1 T11 T21 > >2 T2,2 T22 > >3 T32 T3,2 > >4 T4,1 T4,2 > >5 T4"1 T5'2 > > > >As you see, commas inside double quotes are not a problem. > >I also tried double quotes and single quotes. Double quotes within the > >field need to be changed to 2 double quotes when writing the CSV file. > >Regards, > >Steve Goodhall, PMP > >248-505-5204 mobile > > > >Steve Goodhall, PMP > >248-505-5204 mobile > > > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo > >Sent: Friday, October 10, 2008 1:19 AM > >To: 'Access Developers discussion and problem solving' > >Subject: Re: [AccessD] Exporting/Importing CSV files > > > >Is that why they are called CSV files? - <smile> > > > >CSV=Comma Separated Values. Not only are the "notorious" but "essential" > > > >Max > > > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > >Elizabeth.J.Doering at wellsfargo.com > >Sent: 10 October 2008 03:16 > >To: accessd at databaseadvisors.com > >Subject: Re: [AccessD] Exporting/Importing CSV files > > > > > >David, > > > >You may have better success removing commas from all fields, all the > >time. CSVs are notorious for being comma separated! > > > >Either enforce farther back that commas can't be entered in the fields, > >or use Replace to get rid of them as you are exporting. > > > >HTH, > > > > > >Liz > > > >-----Original Message----- > >From: accessd-bounces at databaseadvisors.com > >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson > >Sent: Thursday, October 09, 2008 7:11 PM > >To: accessd at databaseadvisors.com > >Subject: [AccessD] Exporting/Importing CSV files > > > >Team, > > > >I am wanting to export fields into a CSV file. This I can do using > >Print #. I am also enclosing each field in single quotes thus: > > > >Print #lngFileHandle, "'DET','" & rst!Field1 & "','" & rst!Field2 & > >"','" & rst!Field3 & "'" > > > >Result: > >'DET','1','Joe','Bloggs','10 Kingston Lane' > > > >I can also read the files back into an arrany using Input #: > > > >Input #lngFileHandle, strData(0), strData(2), strData(3), strData(4) > > > >This works fine unless one of the output fields includes a comma. Eg > >'DET','1','Joe','Bloggs','10 Kingston Lane, Jamaca' > > > >In this case the Input# only gets "'10 Kingston Lane" and assumes that " > >Jamaca'" is for the next field. > > > >How do I allow for comma's to be included in fields? > > > > > >Regards > > > >David Emerson > >Dalyn Software Ltd > >Wellington, New Zealand > >-- >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