472,111 Members | 1,842 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,111 software developers and data experts.

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 30904
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.