Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Incomplete dataset imported into SQL Server from large .dbf

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-24 : 10:25:31
stuart writes "I have a fairly sizeable .dbf file (2 gig or 8,000,000 rows) that is created using FoxPro 2.x and I need to analyse in SQL. I import through DTS using dbase 5. The import is successful though lengthy but the problem is is that the resulting data just doesn't seem right. It is like I am seeing a cut down version and row data I expect to see is not there. I am using SQL Server with SP3 applied on a Windows XP install.

Any ideas what I could be doing wrong?"
   

- Advertisement -