Importing data from MySql

[mihabaki]

Hi,

is there any other way to import data from a MySql database then via MyODBC I'm experiencing quite some problems with it (v3.51.12)? , especially with character coding...

thx
Miha

 

[mihabaki]

I have never used MySQL but it probably has the ability to export to .csv files. You can then import the .csv file into Access.

It does have this ability (at least to .txt), but I'm looking for something more "real-time" - like ODBC. The import is to be made too frequent for doing it manually...

Can I do it thru MDAC ???

 

[mihabaki]

Is there any other free driver then MyODBC?

 

[mihabaki]

It's fixed now. The problem was that on the server (mysql) there was a very short timeout setting. I changed it and now MyODBC works just fine.

Thank you for the help,
m.