toraj58
September 28th, 2008, 04:51 PM
How to import data from excel file to mysql database; introducing any migration tool or code snippet will be appriciated.
Click to See Complete Forum and Search --> : [RESOLVED] Excel to MySQL
PeejAvery
September 28th, 2008, 06:54 PM
[ moved ]
PeejAvery
September 28th, 2008, 06:55 PM
You can simply export the Excel document to CSV. Then run the following MySQL query.
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table
LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table
toraj58
September 29th, 2008, 06:41 AM
thnx for your valuable reply
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.