Tried that (Excel) and did not work so... Copied/pasted into Dreamweaver MX 2004 and whacked a comma at the end of each line (only one field - email address).
Saved as a .txt file and imported into SQL Server 2000. It worked but was a painful process. -----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/
