Max Wanadoo
max.wanadoo at gmail.com
Fri Oct 10 00:19:04 CDT 2008
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 This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com