I would use ODBC drivers and INSERT statements, just as if you were talking to a db.
Check your archives for CSV convertor. Or maybe you know that and want to know if FSO is quicker than ODBC to a file? I wonder if you get file lock problems if two users write data at the same time using ODBC to a tab or csv file? HTH, Nick :> -----Original Message----- :> Guys, :> :> sorry. I know this subject has been addressed in one form or another on :> this list, but after searching the archives, I don't seem to find quite :> the answer I am looking for. :> :> I have form data that I want to save in one Excel file. Each :> time the form :> is filled out, the data is written as a new line to the same Excel file. :> I'd like to stay away from storing in a database table then converting to :> Excel, if possible. What is the best way to do this? Should I use the FSO :> to write the new line to a file with the the content type set to :> application_vnd.ms-excel? Or is there a better way? :> --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
