Discussion:
importing excel data into mysql
(too old to reply)
m***@monitor.wc.lt
2017-04-20 20:07:05 UTC
Permalink
You can save an Excel file as a .csv file, when you save it,In excel
File->Save As... Then under file types in the save as window scroll down and
click Comma Seperated Value(.csv), BEWARE that your data is now comma
delimited, so if your data contains comma's this will surely mess up your
column layout definition. Once you have created the CSV file you can then
use the LOAD DATA INFILE utility at a mysql prompt. Check out
http://www.mysql.com/doc/L/O/LOAD_DATA.html. This should be enough to get
you going, let me know if you have any questions..
~DK
PS What does your handle mean, Skate PR 2000? What kind of skating?
-----Original Message-----
Sent: Monday, August 05, 2002 12:58 PM
Subject: importing excel data into mysql
hello.
i want to import about 2500 entries in an ACT database into my mysql
database. ACT can export to Excel and i know that MySQL can import certain
data types.
How exactly, do I go about creating the data file (.csv?) and then importing
it into MySQL?
Thanks a lot,
Kevin
---------------------------------------------------------------------
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use http://excel2sql.esy.es/ Excel to SQL online converter- Generates SQL insert script from xlsx , xls , csv files to easy import in MySQL database or MS SQL server.Hope it helps !
m***@monitor.wc.lt
2017-07-11 15:29:21 UTC
Permalink
Use http://excel2mysql.esy.es/ Excel to SQL online converter- Generates SQL insert script from xlsx , xls , csv files to easy import in MySQL database or MS SQL server.Hope it helps !
Continue reading on narkive:
Loading...