FW: Loading of Excel File into INFORMIX

I wanted to check this product out so I downloaded the file, I mean files. The web site did not offer much in directing me to which files I should download so I downloaded all of them; a "...complete set..." (SQLMover3012.exe), the patch file (SQLMover3012exe.zip), and the Microsoft ODBC Desktop Database Drivers 3.5 for 32-bit programs (wx1350.exe). Not much help to get started either. After I installed the product my WinNT 4.0 O.S. came to a crawl. Investigation showed the culprit to be sqlmover.exe eating almost of my system resources. So beware of this product. I bounced it without seeing it's capabilities. Also, there is no "UnInstall" included with the product! Let me know if I did something wrong. It would be nice to have such a simple solution for pushing data to Informix databases as indicated by your discription of the SQLMover product. To get people to try this product you'll need improvements with documentation and certainly with performance if it truly hogs resources just by loading the executable. Regards, Mark Baumgartner DBA Cardinal Health ---------- From: "Peder Holst" <pederh@elektrosoft.se> Sent: Monday, September 22, 1997 5:24 PM To: informix-list@rmy.emory.edu Subject: Re: Loading of Excel File into INFORMIX With a tool called SQLMover you can pull data from any ODBC compliant database including Excel. All you need is the ODBC driver for Informix and one for Excel. The Excel ODBC driver you can download from www.sqlmover.com. All you need to do in Excel is to define your database. What you do is mark all cells that are going to be accesible for the ODBC driver and go to the "name box" and type a name - now you have an Excel Database. Next you start the ODBC manager and define the Excel file as a datasource. After that start SQLMover and point the destination ODBC driver to your excel file and your destination to the informix DB. Then map the excel db-fields to the Infomix table columns. Now you can transfer manually or schedule the transfer/conversion to be automatic. SQLMover is an automatic or on-demand tool that allows you to replicate automatically between any ODBC compliant datasource including Oracle, Ingres, Informix, DB2, Text files, Excel and SQL Server. SQLMover uses standard, simple or complex SQL Select statement in one end withc means that you can filter and aggregate the info (if you use an intelligent rdbms) and a INSERT, UPDATE, INSERT then UPDATE, UPDATE the INSERT or DELETE statement towards the destination database table. Data conversion can be performed by using the SQL convert option, by using the built in Format Mask functions or by using triggers in the destination database. To evaluate until Oct.31 you can download from www.sqlmover.com (follow the download buttons) and use the evaluation key OSHKSHTD. The key allows you to transfer max. 500 rows per transfer/replication task and max. 5 tasks can be defined. For Data Mart Data Warehousing purposes you can choose to let SQLMover aggregate your data by using SELECT - GROUP BY. (doesn't work with Excel though since it's not a full fledged rdbms) That is if you don't want to replicate each row. Peder Holst, pederh@elektrosoft.se