I don't think Excel is installed on the server. I'm attempting to use the FSO, but I'm getting a permission denied error to the file.
Thanks! > 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]
