We (in Java world) solved this problem sometimes back. If you will be willing to entertain a transition from ASP to Java, please check this out from previous thread "Excel transformation". Peter.
"John, try http://portalfreeportal.com/ there you will find few links, use "XML-to-Excel Transformation". It will display the Excel file that you will be able modify and store locally. But the next invocation of the same link will post unchanged original file. Peter. "John van Rompu" <[EMAIL PROTECTED]> wrote: >Peter, > >I was not on the list at that time and not privy to the discussion. >I however did search the site but it did not appear in my seraches, maybe I >used the wrong key words? >Please provide me with the solution. > >Thank you, > >John > > > > >>Subject: RE: Downloading files to clients >>From: [EMAIL PROTECTED] (Peter Kinev) >>Date: Fri, 13 Sep 2002 16:56:08 -0400 >>X-Message-Number: 22 > >>Just about 2-3 weeks back we've had a discussion on this list under the >thread "Excel transformation" where we offered >>perfect solution for this type of problem. Please, contact us off list to >get an answer. >>Peter. > >>[EMAIL PROTECTED] wrote: > >>Hi All, >> >>Another some what newbie question, I want to put an excel file on a web >>site that users can download to their pc's. I have searched through >>articles and have not been able to find any info.The file on the web must >>not be altered by the users. Just downloaded, then they can do with it >>what they want. I have no CGI capabilties currently, but I will be moving >>the site in the near future and can go either way CGI(perl) or ASP(VB), I >>am not a pro at coding either but do have some experience. >> >>Any advise or direction where I could get this info would be highly >>appreciated. >> >>Thanks >> >>John Chuck Scholton <[EMAIL PROTECTED]> wrote: >Here's the problem I am faced with, I built an application in >ASP which allow for people to upload Excel data files and >import information into a MS SQL database. �This works >great save one problem. �Some times people upload files >with Columns containing Intermixed data types, so all the >data is not imported. �This is one of the draw backs to how >ADO accesses Excel files. �Anyways, I want to take uploaded >Excel files and convert them to a more ADO friendly format, >and use the new file for grabbing the data from for import! >My only requirement is that this be a Command line Utility >or Active X Component. �Either will do, and I don't really >care what format Excel files get converted to just something >that is ADO friendly.. and get's rid of the intermixed data >type problems.. Anybody know of any utilities which can >operate in a Windows Environment which can pull this off? > >-Chuck Scholton > > > > >____ � The WDVL Discussion List from WDVL.COM � ____ >To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] > � � � Send Your Posts To: [EMAIL PROTECTED] >To change subscription settings to the wdvltalk digest version: > � �http://wdvl.internet.com/WDVL/Forum/#sub > >________________ �http://www.wdvl.com �_______________________ > >You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] >To unsubscribe send a blank email to %%email.unsub%% > __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
