I have a problem with importing a huge Database to Access. I have created a ODBC Connection and selected the database in access.
我有一个问题，进口一个巨大的数据库访问。我创建了一个ODBC连接，并选择了access中的数据库。
The Database has 5 Tables the biggest Table has about 9 mio records.
数据库有5个表，最大的表有大约9个mio记录。
The import of the smallest 2 Tables work's fine. (About 600k and 1 mio records).
最小的两个表的导入工作正常。(约60公里及1米的纪录)。
In the ODBC Database configuration i have set the setting "Allow Big data result" and "Don't cache results of forward-only cursors".
在ODBC数据库配置中，我设置了“允许大数据结果”和“不缓存只向前的游标结果”的设置。
But the import of the big Tables fail with message odbc call failed. I have no idea, how to solve the problem?
但是，由于消息odbc调用失败，大表的导入失败了。我不知道如何解决这个问题。
1 个解决方案
#1
2
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
我希望这能帮助你。打开表后，单击Last record，以便在Access的Datasheet视图中显示链接表中的所有记录。不要选择要显示的链接表中的所有记录。相反，只选择数量有限的记录。你也可以在这里找到更多的细节。在这里
#1
2
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
我希望这能帮助你。打开表后，单击Last record，以便在Access的Datasheet视图中显示链接表中的所有记录。不要选择要显示的链接表中的所有记录。相反，只选择数量有限的记录。你也可以在这里找到更多的细节。在这里