Zach
Save your spreadsheet as a CSV (comma separated value) file.
---------------------------------------------------------------
jno...@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
After I save the spreadsheet as a CSV file how do I import the data
into a MySQL table?
>| 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';