how to convert mysql nga database to ms access?

[AMD_earl]

---

guys..i really need ur help..
unsaon na pag convert ang database nga mysql ang format to ms access..

i heard naa daw?..thanks..pls

salamat kaayo

[dodie]

guys..i really need ur help..
unsaon na pag convert ang database nga mysql ang format to ms access..

i heard naa daw?..thanks..pls

salamat kaayo

It's true there are softwares that can do that into binary/format capabilities.

But there is much easier way......... generate that data into .csv or .sql file, or any format.... which is compatible to ms access inputs. Querying all the data from mysql then generate the necessarry commands into ms access queries and store it as text file.

From the text file, run it inside msaccess. The rest is up to you how your queries are generated.

[MarkCuering]

Hi earl,

1. Is this a commercial database?
2. Can you tell me what are those common fields on your MySQL DB? is there any Decimal and Currency field?
3. Is this a complete migration? You don't need anymore the MySQLDB? or you need to synchronize from your actual MySQLDB & MSACCESS?

Why you want to migrate by the way? aside from multi-transaction benefits from MySQL, a DB with over 300K records are more faster during queries than using MSACCESS.

I hope you will make some few testing first. Build you own small database in MySQL and examine how does MSACCESS treat your datas, there are fields that are not compatible when you migrate from MySQL to MSACCESS. I hope you are aware on that. If you can't make your own script go to Search Results: Contrib I've seen some contributed scripts before,that imports data from MySQL into MSACCESS database via ODBC.