How to Change Excel sheet containing data size 10Mb into SQL file?

Question

Hello All..
Please i want to convert my Excel sheet that contains a big data into a SQL file.
the excel sheet is around 10MB, and i want to convert it to SQL because i want to upload it on a website.

Thank you

Answer 1

You have two options:



1) You need to convert the data into queries -- which can be done pretty easily in Excel by adding columns and populating them with the query structure. For example if you have the following data in Excel:



'Name', 'Age', 'Birthdate'



You can just add columns to get the query structure in there such as:



INSERT INTO table (column1, column2, column3) VALUES ('Name', 'Age', 'Birthdate');



2) You need to use an import tool. If this is a MySQL database, then 'mysqlimport' will allow you to import a text file like this as you can save the Excel spreadsheet in CSV (comma separated values) format and use 'mysqlimport --fields-terminated-by=,' to help it parse the data



Neither option is particularly hard.

Answer 2

In keeping with the question on importing the Excel 2007 data to SQL Server 2005, I want to furnish you the ideas as follows: 1. Connection string challenge: Please assess in case you are competent to connect both Excel 2007 and SQL Server 2005 as the information source successfully. The excelConnection appears to be to find as you provided. Then that you would be able to additionally add "HDR=sure" to indicate that the primary row comprises columnnames, now not knowledge. "HDR=No;" suggests the opposite. This will hinder the first row harassed when importing to the SQL tables. 2. Please experiment your ODBC SQL Server connection string in order that the connection to SQL Server is right. Except the ODBC, which you can also use SqlConnection and execute the SqlCommand object with the announcement that involves the excelConnection to your VB.Web code, but no longer just combine the whole in one SQL assertion. The following article suggests you the best way: Import Excel sheet into table three. Except the above approaches, that you can don't forget to use SqlBulkCopy category to import. The following article shows you the illustration: Import Excel Spreadsheet information into SQL Server Database desk utilising SqlBulkCopy four. There's a KB article in MSDN on the topic. Despite the fact that the article is not applied for SQL Server 2005, that you may also be trained on SQL Server data Transformation services (DTS), Microsoft SQL Server 2005 Integration services (SSIS), SQL Server linked servers and SQL Server allotted queries. They're important on your work. Tips on how to import information from Excel to SQL Server Hope that can help you.

Answer 3

Nor easy. Considering the data needs to be organised into different tables linked by key fields, you will probably need to write code in php to run on the suite to create all the appropriate tables and break the data into several spread sheets.

Answer 4

First you have to convert that 10 mb file .lower memory so that you can upload it on the website