469,110 Members | 2,009 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,110 developers. It's quick & easy.

Import excel file into mysql database

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
8 30736
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
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
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
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
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
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
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
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.

Similar topics

1 post views Thread by Johnny | last post: by
6 posts views Thread by sejal17 | last post: by
1 post views Thread by orked | last post: by
4 posts views Thread by orked | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.