What version of Excel (2000) and what version of ColdFusion (latest 6.1), what database method to import into SQL Server 2000 SP3?
Ouch! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Austin Sent: Tuesday, 18 January 2005 6:28 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Advice appreciated on data conversion Quick and dirty? Use excel to munge the data into a spread sheet. It is probably <cr> terminated and excel should handle that OK. Once you have it in excel, you can use MS SQL DTS to import it (using the excel as a data source) or export from excel into delimited form to import to the DB using a CFML script or such. Regards, Jon On Tue, 18 Jan 2005 18:15:44 +1100, Peter Tilbrook <[EMAIL PROTECTED]> wrote: > Any ideas on parsing this from a flat text file (.txt) into a database > (assuming row one in file is column name?). --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
