By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,306 Members | 1,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,306 IT Pros & Developers. It's quick & easy.

Import excel file into mysql database

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
<jn****@yourpantsbigpond.net.au> wrote:
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
<jo****@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.
---------------------------------------------------------------
jn****@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?
Jul 19 '05 #2

P: n/a
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
<jo****@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.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #3

P: n/a
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
<jo****@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.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #4

P: n/a
On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
<jn****@yourpantsbigpond.net.au> wrote:
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
<jo****@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.
---------------------------------------------------------------
jn****@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?
Jul 19 '05 #5

P: n/a
On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
<jn****@yourpantsbigpond.net.au> wrote:
On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
<jo****@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.
---------------------------------------------------------------
jn****@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?
Jul 19 '05 #6

P: n/a
On Tue, 20 Jan 2004 00:38:00 GMT, in mailing.database.mysql Johnny
<jo****@agent.com> wrote:
| On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
| <jn****@yourpantsbigpond.net.au> wrote:
|
| >On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| ><jo****@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';

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #7

P: n/a
On Tue, 20 Jan 2004 00:38:00 GMT, in mailing.database.mysql Johnny
<jo****@agent.com> wrote:
| On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
| <jn****@yourpantsbigpond.net.au> wrote:
|
| >On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| ><jo****@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';

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #8

P: n/a
On Tue, 20 Jan 2004 00:38:00 GMT, in mailing.database.mysql Johnny
<jo****@agent.com> wrote:
| On Tue, 20 Jan 2004 00:12:40 GMT, Jeff North
| <jn****@yourpantsbigpond.net.au> wrote:
|
| >On Mon, 19 Jan 2004 23:17:01 GMT, in mailing.database.mysql Johnny
| ><jo****@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';

---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.