importing excel data into mysql
David Kramer
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
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>
