![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Hi, I have an issue trying to load a dBase table in a SQLServer 2000 database by DTS.Trying to open this table for copy it, DTS give next message: Source error: Microsoft JET Database Engine Description: Unexpected error from external database driver (10023) It's funny, cause from Excel I can open the .dbf file and it works, and after doing that, if I use a Excel connection for open that table DTS works successfully. I suppose this issue is an index problem of the file .cdx. This dBase DB has a lot of tables, but only give me error a little few. Has somebody a better solution please? Any solution is better than this, I'm sure Thanks very much. |
#3
| |||
| |||
|
|
Try importing the tables (not linking) into Access first. If successful you can more easily bring them into SQL Server. Worked for me with Lotus Notes DB "Ray" wrote: Hi, I have an issue trying to load a dBase table in a SQLServer 2000 database by DTS.Trying to open this table for copy it, DTS give next message: Source error: Microsoft JET Database Engine Description: Unexpected error from external database driver (10023) It's funny, cause from Excel I can open the .dbf file and it works, and after doing that, if I use a Excel connection for open that table DTS works successfully. I suppose this issue is an index problem of the file .cdx. This dBase DB has a lot of tables, but only give me error a little few. Has somebody a better solution please? Any solution is better than this, I'm sure Thanks very much. |
![]() |
| Thread Tools | |
| Display Modes | |
| |