importing excel data into mysql

14 views
Skip to first unread message

David Kramer

unread,
Aug 5, 2002, 4:19:45 PM8/5/02
to
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-----
From: Sk8...@aol.com [mailto:Sk8...@aol.com]
Sent: Monday, August 05, 2002 12:58 PM
To: my...@lists.mysql.com
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

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thr...@lists.mysql.com>
To unsubscribe, e-mail
<mysql-unsubscribe-dkramer=refle...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysql-thr...@lists.mysql.com>
To unsubscribe, e-mail <mysql-unsubscribe-mysql=freebsd.csie...@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Nathan Cook

unread,
Aug 5, 2002, 4:22:19 PM8/5/02
to
Rearrange the columns in your excel spreadsheet to match the columns of
your mysql table, save as a CSV (Comma Separated) and then import.

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#LO
AD_DATA

----- Original Message -----
From: <Sk8...@aol.com>
To: <my...@lists.mysql.com>
Sent: Monday, August 05, 2002 1: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
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thr...@lists.mysql.com>
> To unsubscribe, e-mail

<mysql-unsubscribe-security=pcsed...@lists.mysql.com>

Message has been deleted

ma...@monitor.wc.lt

unread,
Jul 11, 2017, 11:29:23 AM7/11/17
to
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 !

Reply all
Reply to author
Forward
0 new messages