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

Importin a MySQL database into MS Access

P: n/a
Hi,
I would like to import the tables from MySQL database into Access
database and I am not sure how to go about it. I tired to "Import
External Data" from Access, selected "ODBC database" from file type
dropdown, selected "New data source" and picked SQL Server from the
list. I specified the server name (mydomain.com) along with user id
and password. But when I clicked on "Next", I got: "connection failed:
SQL Server Error:10060, [tcp/ip socket]ConnectionOpen(Connect())"
followed by: "Connection failed: SQL Server error: 17 [tcp/ip
socket]SQL server does not exist or access denied."
I exported the MySQL tables into a file, (using PHPMyAdmin, as well as
mysqldump) using SQL format, and created a blank database in Access
but don't know how to import the tables into Access.
I am kind of green, so please be gentle! If you can outline what I
need to do, I would really appreciate it.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
In message <b3**************************@posting.google.com >, Xerxes
<as*******@hotmail.com> writes
Hi,
I would like to import the tables from MySQL database into Access
database and I am not sure how to go about it. I tired to "Import
External Data" from Access, selected "ODBC database" from file type
dropdown, selected "New data source" and picked SQL Server from the
list.


That's the problem, you should have picked MySQL from that list. If you
see it on the list then you need to install the MySQL ODBC software on
your machine.


--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #2

P: n/a
as*******@hotmail.com (Xerxes) wrote in message news:<b3**************************@posting.google. com>...
Hi,
I would like to import the tables from MySQL database into Access
database and I am not sure how to go about it. I tired to "Import
External Data" from Access, selected "ODBC database" from file type
dropdown, selected "New data source" and picked SQL Server from the
list. I specified the server name (mydomain.com) along with user id
and password. But when I clicked on "Next", I got: "connection failed:
SQL Server Error:10060, [tcp/ip socket]ConnectionOpen(Connect())"
followed by: "Connection failed: SQL Server error: 17 [tcp/ip
socket]SQL server does not exist or access denied."
I exported the MySQL tables into a file, (using PHPMyAdmin, as well as
mysqldump) using SQL format, and created a blank database in Access
but don't know how to import the tables into Access.
I am kind of green, so please be gentle! If you can outline what I
need to do, I would really appreciate it.


try:
http://dev.mysql.com/doc/connector/o....html#MSAccess
Nov 13 '05 #3

P: n/a
tw*@gate.net (Tom Warren) wrote in message news:<f4**************************@posting.google. com>...
as*******@hotmail.com (Xerxes) wrote in message news:<b3**************************@posting.google. com>...
Hi,
I would like to import the tables from MySQL database into Access
database and I am not sure how to go about it. I tired to "Import
External Data" from Access, selected "ODBC database" from file type
dropdown, selected "New data source" and picked SQL Server from the
list. I specified the server name (mydomain.com) along with user id
and password. But when I clicked on "Next", I got: "connection failed:
SQL Server Error:10060, [tcp/ip socket]ConnectionOpen(Connect())"
followed by: "Connection failed: SQL Server error: 17 [tcp/ip
socket]SQL server does not exist or access denied."
I exported the MySQL tables into a file, (using PHPMyAdmin, as well as
mysqldump) using SQL format, and created a blank database in Access
but don't know how to import the tables into Access.
I am kind of green, so please be gentle! If you can outline what I
need to do, I would really appreciate it.


try:
http://dev.mysql.com/doc/connector/o....html#MSAccess


Thanks Tom.
I followed the instuctions on the page, created DSN, and tried to
import the tables from MySQL into Access, but I get the following
error:
"You cannot use ODBC to import from, export to, or link an external
Microsoft Jet or ISAM table to your database."
The actual database is on our ISP's server, so I used PHPMyAdmin
console to export the tables to a file (db.sql) and saved it on my
desktop. I used the db.sql file to create the database on my PC
(running WinMySQL).
(If I try to connect to create DSN using remote database, on the ISP
server, it says:"[MYSQL][ODBC 3.51 Driver] Host xxx.xxx.xxx.xxx is not
allowed to connect to this MySQL server.")

When I looked at the db.sql file, at the end of each table creation
code, it says type is MyISAM:
CREATE TABLE `TableName` (
.....
....
) TYPE=MyISAM AUTO_INCREMENT=4 ;

Thanks.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.