Insert Excel OR CSV File into MySQL OR MSSQL Database
-
Hello, I have scoured the web, found MANY apps that let you do this, however I am in need of a free solution. I have product sheets in an xls file that need to be put in a database, and I cannot type a query to insert hundreds of thousands of items into a db manually. Is there any free, easy way to insert Excel OR CSV File into MySQL OR MSSQL Database? I appreciate any help at all, thank you! :)
-
Hello, I have scoured the web, found MANY apps that let you do this, however I am in need of a free solution. I have product sheets in an xls file that need to be put in a database, and I cannot type a query to insert hundreds of thousands of items into a db manually. Is there any free, easy way to insert Excel OR CSV File into MySQL OR MSSQL Database? I appreciate any help at all, thank you! :)
The main problem will be that Excel is unstructured data, if all your sheets are well formed and are all EXACTLY the same the you can write a program with 3 parts: Folder scan that identifies each xls file importer that reads each xls into a data table (either cell by cell or using Jet) DAL to write the data table to the database. Expecting a "free" tool to do this is a little much.
Never underestimate the power of human stupidity RAH
-
Hello, I have scoured the web, found MANY apps that let you do this, however I am in need of a free solution. I have product sheets in an xls file that need to be put in a database, and I cannot type a query to insert hundreds of thousands of items into a db manually. Is there any free, easy way to insert Excel OR CSV File into MySQL OR MSSQL Database? I appreciate any help at all, thank you! :)
SSIS. It's free if you have SQL Server 5005 2005 Developer or above. You can do it in minutes if you have it. :) Edit: Fixed typo
SG Aham Brahmasmi!
-
Hello, I have scoured the web, found MANY apps that let you do this, however I am in need of a free solution. I have product sheets in an xls file that need to be put in a database, and I cannot type a query to insert hundreds of thousands of items into a db manually. Is there any free, easy way to insert Excel OR CSV File into MySQL OR MSSQL Database? I appreciate any help at all, thank you! :)
For MYSQL I use the LOAD DATA SQL. LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...] http://dev.mysql.com/doc/refman/5.1/en/load-data.html