Discussion:
Import excel file into mysql database
(too old to reply)
Johnny
2004-01-19 23:17:01 UTC
Permalink
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.

Zach
Jeff North
2004-01-20 00:12:40 UTC
Permalink
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| 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.
---------------------------------------------------------------
***@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Johnny
2004-01-20 00:38:00 UTC
Permalink
On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
Post by Jeff North
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| 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?
Jeff North
2004-01-20 09:20:10 UTC
Permalink
On Tue, 20 Jan 2004 00:38:00 GMT, in mailing.database.mysql Johnny
| On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
|
| >On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| >
| >>| 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';

---------------------------------------------------------------
***@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
m***@monitor.wc.lt
2017-04-20 20:00:59 UTC
Permalink
Post by Johnny
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.
Zach
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:22:52 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 !
Loading...