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

need help dumping data to easily import into MS Access

P: n/a
I have a db that I need to dump into a format that can be easily read my MS
Access. I tried the dump with regular PHPAdmin. Then I used the dump to
run a query in MS Access.

Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to
interpret that.

Any ideas for easily getting whatever kind of data from MySQL to MS Access?

Many thanks in advance!
Jul 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
In article <5M***************@bignews4.bellsouth.net>,
no****@nonegiven.net says...
I have a db that I need to dump into a format that can be easily read my MS
Access. I tried the dump with regular PHPAdmin. Then I used the dump to
run a query in MS Access.

Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to
interpret that.

Any ideas for easily getting whatever kind of data from MySQL to MS Access?

Many thanks in advance!


Have you tried installing the ODBC connector?
(http://www.mysql.com/products/myodbc/index.html)

That lets you connect to the MySQL database and link to the tables on
the MySQL server. You can then just use append queries that read from
the MySQL server table and dump the data into a local MSAccess table.
Jul 19 '05 #2

P: n/a
In article <5M***************@bignews4.bellsouth.net>,
no****@nonegiven.net says...
I have a db that I need to dump into a format that can be easily read my MS
Access. I tried the dump with regular PHPAdmin. Then I used the dump to
run a query in MS Access.

Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to
interpret that.

Any ideas for easily getting whatever kind of data from MySQL to MS Access?

Many thanks in advance!


Have you tried installing the ODBC connector?
(http://www.mysql.com/products/myodbc/index.html)

That lets you connect to the MySQL database and link to the tables on
the MySQL server. You can then just use append queries that read from
the MySQL server table and dump the data into a local MSAccess table.
Jul 19 '05 #3

P: n/a
That would work except the server is a hosting company and I need to do this
over encrypted lines so the data is never compromised.

I was hoping to dump the MySQL data then rebuild it in Access - doesn't
work.

There's a INTO OUTFILE command that looks interesting in MySQL I'll check
out.
"Toshi1873" <to********@nowhere.com> wrote in message
news:MP************************@news-50.giganews.com...
In article <5M***************@bignews4.bellsouth.net>,
no****@nonegiven.net says...
I have a db that I need to dump into a format that can be easily read my MS Access. I tried the dump with regular PHPAdmin. Then I used the dump to run a query in MS Access.

Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to interpret that.

Any ideas for easily getting whatever kind of data from MySQL to MS Access?
Many thanks in advance!


Have you tried installing the ODBC connector?
(http://www.mysql.com/products/myodbc/index.html)

That lets you connect to the MySQL database and link to the tables on
the MySQL server. You can then just use append queries that read from
the MySQL server table and dump the data into a local MSAccess table.

Jul 19 '05 #4

P: n/a
That would work except the server is a hosting company and I need to do this
over encrypted lines so the data is never compromised.

I was hoping to dump the MySQL data then rebuild it in Access - doesn't
work.

There's a INTO OUTFILE command that looks interesting in MySQL I'll check
out.
"Toshi1873" <to********@nowhere.com> wrote in message
news:MP************************@news-50.giganews.com...
In article <5M***************@bignews4.bellsouth.net>,
no****@nonegiven.net says...
I have a db that I need to dump into a format that can be easily read my MS Access. I tried the dump with regular PHPAdmin. Then I used the dump to run a query in MS Access.

Errors occurred because MySQL inserts a backslash, "\", in front of an
apostophe that user enters in a text field and MS Access doesn't know how to interpret that.

Any ideas for easily getting whatever kind of data from MySQL to MS Access?
Many thanks in advance!


Have you tried installing the ODBC connector?
(http://www.mysql.com/products/myodbc/index.html)

That lets you connect to the MySQL database and link to the tables on
the MySQL server. You can then just use append queries that read from
the MySQL server table and dump the data into a local MSAccess table.

Jul 19 '05 #5

P: n/a
probably mysqldump is what you are looking for. It can dump all the
databases with all the tables or just the table your select. You can dump
the data to a text file or onto the screen

hope this helps

sanjay
"NotGiven" <no****@nonegiven.net> wrote in message
news:5M***************@bignews4.bellsouth.net...
| I have a db that I need to dump into a format that can be easily read my
MS
| Access. I tried the dump with regular PHPAdmin. Then I used the dump to
| run a query in MS Access.
|
| Errors occurred because MySQL inserts a backslash, "\", in front of an
| apostophe that user enters in a text field and MS Access doesn't know how
to
| interpret that.
|
| Any ideas for easily getting whatever kind of data from MySQL to MS
Access?
|
| Many thanks in advance!
|
|
Jul 19 '05 #6

P: n/a
probably mysqldump is what you are looking for. It can dump all the
databases with all the tables or just the table your select. You can dump
the data to a text file or onto the screen

hope this helps

sanjay
"NotGiven" <no****@nonegiven.net> wrote in message
news:5M***************@bignews4.bellsouth.net...
| I have a db that I need to dump into a format that can be easily read my
MS
| Access. I tried the dump with regular PHPAdmin. Then I used the dump to
| run a query in MS Access.
|
| Errors occurred because MySQL inserts a backslash, "\", in front of an
| apostophe that user enters in a text field and MS Access doesn't know how
to
| interpret that.
|
| Any ideas for easily getting whatever kind of data from MySQL to MS
Access?
|
| Many thanks in advance!
|
|
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.