CODEWITHSUNDEEP
mysqlsqldatabaseodbc
user3005837
user3005837

Reputation: 11

Import huge mysql database to access

I have a problem with importing a huge Database to Access. I have created a ODBC Connection and selected the database in access.

The Database has 5 Tables the biggest Table has about 9 mio records.

The import of the smallest 2 Tables work's fine. (About 600k and 1 mio records).

In the ODBC Database configuration i have set the setting "Allow Big data result" and "Don't cache results of forward-only cursors".

But the import of the big Tables fail with message odbc call failed. I have no idea, how to solve the problem?

Upvotes: 1

Views: 203

Answers (1)

Amador
Amador

Reputation: 192

I hope this help you out . Click Last record as soon as the table is opened in order to display all records in the linked table in the Datasheet View of Access . Do not select all records in the linked table to be displayed. Instead, select only a limited number of records. also you can look here for more details. Here

Upvotes: 2

Related Questions