Error loading a dbf table to a SQLServer DB by DTS -- sql server dts

Ray
10/20/2006 7:56:02 AM

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

DeeBee
11/1/2006 2:03:02 PM

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

[quoted text, click to view]

Ray
11/2/2006 3:25:02 AM

Access returns the same error trying import the same tables, it doesn't
happen with all the tables

"Unexpected error from external database driver (10023)"

Thanks

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Error loading a dbf table to a SQLServer DB by DTS