Import excel file into mysql database
Johnny
text file into a MySql database. I have done this with both access
and SQL Server and am looking for a way to do this in MySql. I have
several hundred items i want to import into a parts database that is
currently in an excel file but can be saved as comma separated or
other format. Any help would be greatly appreciated. Thanks in
advance.
Zach
Jeff North
Save your spreadsheet as a CSV (comma separated value) file.
---------------------------------------------------------------
jno...@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Johnny
After I save the spreadsheet as a CSV file how do I import the data
into a MySQL table?
Jeff North
<joh...@agent.com> wrote:
>| On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
>| <jno...@yourpantsbigpond.net.au> wrote:
>|
>| >On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
>| ><joh...@agent.com> wrote:
>| >
>| >>| I was looking for information on how to import an excel file or other
>| >>| text file into a MySql database. I have done this with both access
>| >>| and SQL Server and am looking for a way to do this in MySql. I have
>| >>| several hundred items i want to import into a parts database that is
>| >>| currently in an excel file but can be saved as comma separated or
>| >>| other format. Any help would be greatly appreciated. Thanks in
>| >>| advance.
>| >
>| >Save your spreadsheet as a CSV (comma separated value) file.
>|
>| After I save the spreadsheet as a CSV file how do I import the data
>| into a MySQL table?
Look under the Load Data instruction. I use the following:
LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE
pnp_docs_current FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES
TERMINATED BY '\n';
