• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

Loading DBF file to MS SQL 2000

I would like to use the DTS utility to import the data coming from a dbf codebase file (source) into MS SQL 2000 database (destination).

What my problem is that there are some records from the dbf has a delete flag turned on, when I do the import, everything was inserted into SQL database except for those marked delete ones. What can I do? Any suggestion of the ODBC driver?

If all records can be imported into SQL 2000 with a column specified whether this record are deleted or not, then it would be perfect. Thanks.

I can send you the dbf file for your investigation. Thanks.
0
acwng
Asked:
acwng
1 Solution
 
Anthony PerkinsCommented:
I seem to recall that you could change a registry entry at:
HKEY_LOCAL_MACHINE \SOFTWARE \MICROSOFT \JET \???\ENGINES\XBASE\Deleted

from on (1) to off(0) and it will include them all.  Not exactly what you want, but closer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now