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/
