Quote:
My question is: why there is so big different?
ODBC Import is done in three steps.
- Retrieving the data from the source
- Creating insert statement
- Inserting the data in target datasource
Quote:
on the other hand, when i import mysql database into Access 2000 in the Access 2000, it just takes me severl mintus (same size).
It might be that when we are retrieving data from Access, Access is taking more time then MySQL to parse the query and return the data whereas MySQL is doing it ( obviously !!! ) more quickly. Therefore the time difference in importing same amount of data.
Hope it helps.