SHE BANGS! that's the way I was doing it. I was hoping there was some sort of function like csv2query() already implemented :)
Cheers >>> [EMAIL PROTECTED] 05/28/04 10:52am >>> I reckon (theoretically) the easiest way would be with OPENQUERY() no need for a DSN on the file just read it directly... BANG... -----Original Message----- From: Peter Galipo [mailto:[EMAIL PROTECTED] Sent: Friday, 28 May 2004 12:48 PM To: CFAussie Mailing List Subject: [cfaussie] reading a csv file Hi All, I have a csv file with about 8 columns of data. I would like to read this file into a query structure somehow. Is there an easy way to do this? Cheers, Pete --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-6 August - www.tq.com.au/tfconf --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
