且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL Server导入和导出向导错误:“索引超出数组的范围"通过32位ODBC数据源?

更新时间:2022-04-14 23:01:36

当尝试从用于Sage MAS90软件的32位ProvideX ODBC驱动程序从DNS导入数据到SQL时,我收到了同样的错误.通过首先创建目标表,然后使用该选项编写查询而不是从一个或多个表或视图复制数据来解决此问题.

I received this same error when trying to import data into SQL from a DNS for 32 bit ProvideX ODBC driver for Sage MAS90 software. I got around it by creating the destination table first and then using the option to write a query instead of copy data from one or more tables or view.