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 y
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 Lis