SQL Server DTS? Not command line (well maybe but too geeky for me ;-) but you could set = up a job to "cleanse" the data and put it into it's new home ready for = whatever you wish to do with it.
Jay -----Original Message----- From: Chuck Scholton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 September 2002 15:40 To: [EMAIL PROTECTED] Subject: [wdvltalk] Converting Excel files to CSV or other formats. 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 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]
