dbTalk Databases Forums  

Error loading a dbf table to a SQLServer DB by DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error loading a dbf table to a SQLServer DB by DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ray
 
Posts: n/a

Default Error loading a dbf table to a SQLServer DB by DTS - 10-20-2006 , 09:56 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

Thanks very much.

Reply With Quote
  #2  
Old   
DeeBee
 
Posts: n/a

Default RE: Error loading a dbf table to a SQLServer DB by DTS - 11-01-2006 , 04:03 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

"Ray" wrote:

Quote:
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.

Reply With Quote
  #3  
Old   
Ray
 
Posts: n/a

Default RE: Error loading a dbf table to a SQLServer DB by DTS - 11-02-2006 , 05:25 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


"DeeBee" wrote:

Quote:
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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.