Save your excel file as CSV, and run the following command:
mysqlimport --fields-optionally-enclosed-by=
--fields-terminated-by=, --lines-terminated-by=\r\n
--user=YOUR_USERNAME --password YOUR_DATABASE YOUR_TABLE.csv
Make sure not to include the headers of your excel columns and to set
up your table beforehand. Don't forget to replace all necessary parts
in the command above.
If you're not on Windows you should probably use \n instead of \r\n
for the newline character.
On Fri, Sep 5, 2008 at 1:12 PM, Nasreen Laghari
[EMAIL PROTECTED] wrote:
Hi Evert,
I have attached it again.
Regards,
Nasreen
- Original Message
From: Evert Lammerts [EMAIL PROTECTED]
To: Nasreen Laghari [EMAIL PROTECTED]
Sent: Friday, September 5, 2008 11:03:18 AM
Subject: Re: [PHP-DB] Import Excel sheet into SQL
Attachment didn't make it
On Fri, Sep 5, 2008 at 12:00 PM, Nasreen Laghari
[EMAIL PROTECTED] wrote:
Hi,
How can I import Excel sheet into MS-SQL. The data I have saved in excel
sheet is in cells, snapshot is attached in this email.
I am using sqlmyAdmin. and tried using import but getting error Invalid
Count on line1
Help required!!!
Nasreen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php