Import data from Access Database to MYSQL

General discussions related to php

Moderators: macek, egami, gesf

vikaspa
New php-forum User
New php-forum User
Posts: 21
Joined: Wed Jun 19, 2002 10:03 pm

Import data from Access Database to MYSQL

Postby vikaspa » Mon Aug 12, 2002 12:20 am

Dear All,


I have some data in access database.
I wish to import it (keeping the same structure) in MySQL.

Please let me know whether any one know smart way to do this.

Also I want to know what will be procedure for importing data from databases like Oracle, Sybase, Informix etc

I donot know whether thsi is answered or not.

With regards
Vikas Atahavale
e-mail :vikaspa@vsnl.com

Note : I am really appreciate your valuable suggestion

Jay

Postby Jay » Mon Aug 12, 2002 2:35 am

Well, Access is an ODBC complient DB. There is software around called MySQL ODBC (search on Google) that might let you transfer this over. I've never used it myself, so I don't know. But apparently some people using it to manipulate their MySQL on a remote installation through Access on their local machine. If it can do that then I'm presuming there's a way to get it there in the first place :)


Return to “PHP General”

Who is online

Users browsing this forum: No registered users and 0 guests