Menu
▾
▴
#389 converting db from mysql to Access
closed
1
2004-01-23
2003-12-19
Anonymous
No
I'd like to convert my MySql 4.0.16 database (It's on
somebody else's server) to a Database in Microsoft
Access (version in Office Xp-package). I want to do this
for analysing purposes.
I tried downloading a sql-dump and importing that
through sql in access, but that doesn't work. Anybody
knows a way to do this? And while were at it, would it
be possible to extract the database from Access and
put it back in the MySql-database (that would make a
extra backup-function).
thanks,
Kroesss - kroesss@hotmail.com
Logged In: YES
user_id=210714
What error do you get when importing in Ms Access?
About conversion from Access, on MySQL site, in the contrib
section if I recall correctly, there is a script to do that.
Logged In: YES
user_id=210714
What error do you get when importing in Ms Access?
About conversion from Access, on MySQL site, in the contrib
section if I recall correctly, there is a script to do that.
Logged In: YES
user_id=210714
What error do you get when importing in Ms Access?
About conversion from Access, on MySQL site, in the contrib
section if I recall correctly, there is a script to do that.
Logged In: NO
I get a error saying that the create table-command has a
error. I'm using the standard-SQL-export format.
Kroesss - kroesss@hotmail.com
Logged In: YES
user_id=418833
Kroesss, shouldn't you be able to import the database through
ODBC?
Logged In: NO
you meen that I can connect access with the mysql-
database? That would work for me!
Thanks, I'll look into it. I never thought that would be
possible.
Kroesss - kroesss@hotmail.com
Logged In: YES
user_id=418833
Access may import tables through ODBC. You just need MySQL's
ODBC driver which is offered on the MySQL website.
Logged In: NO
OK, I downloaded and installed the ODBC-driver from mysql.
Now all it needs is the host where it can find the database,
and there is a problem. Like many databases, it runs
on "localhost". Anybody any idea how I can translate this into
a host it can find?
Thanks,
Kroesss - kroesss@hotmail.com