Thanks! I decided to just use the FSO to print the contents in an HTML table to a file that is included in an asp page with the csv mime-type.
It seems to work fine. When I view the Excel file, however, there are no gridlines. Is there a way to activate gridlines without having to manually turn them on after I open the Excel file? There doesn't seem to be any documentation stating this can or cannot be done. Thanks! > 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]
