Hm, this is not as simple as it looks! There are som side problems. Try using the ODBC driver for Excel or comma delimited format. This cuases some problems sometimes but will deal with the synchronization itself.
If you want to do it directly writting to the file FSO is not the best way. you will need something with extended control over the file open/sharing mode and also (very important) you should keep the stream object that points the file into the Application! This will allow some synchronization - not doing so may lead to two major problems - losing the entire file or open errors while another request is in process. See if these components will not help: http://www.newobjects.com/prodct/ID/63 See Storages and Files - something like extended FSO. Also there are som constants and flags in include files (in ASP format) the docs are not complete thus comments around the constants in the include would be more useful at this time. Long ago I used FSO to store something in a file (counter, DBless chat) but the above problem happened (file empty). So be careful if you choose the direct file access. Michael -----Original Message----- From: 15Seconds Editor [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 5:10 PM To: ActiveServerPages Subject: RE: Excel Question 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
