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.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-11-04 : 17:31:22
|
| I need some help of import a .dbf file into sql2000. The file was created by a third party shipping application. It has 58,000 rows, and about 150 columns.I understand it could be Foxpro or dBaseX, or any other database file.I could link to it through access 2000. I have to give it an index file (.ndx) during the process. And that is how I know above numbers. But that's about all I could do to it. I want to query it. I tried to export it to txt, xls, or DTS it into sql2k, but don't have any luck.I got this message."Unexpected error from external database driver (10019)"Any body can help out? Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-04 : 17:34:30
|
| You'll need to talk to the vendor of the third party shipping application to determine what dbms the file is. Once you know this information, you'll then select the appropriate driver for that dbms within the DTS package. You should then be able to import the data.Tara Kizer |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2005-11-05 : 07:57:44
|
| That is a good idea. They are out of business. Also, on the property page of the linked table, it says it is dbase IV. I have tried all the dBase and Foxpro drivers I have, I need find somewhere to download more compliable ones maybe? |
|
|
|
daspeac
Starting Member
4 Posts |
Posted - 2009-11-20 : 09:13:43
|
| Hi Hommer. I believe that you can fix these errors more easier, try the sql 2005 in recovery program and open affected database. Feel free parsing affected database as well as its corrupted backup (if available), Recovery Toolbox for SQL Server (spam removed)gives very good chances to restore the entire database.yes, I know that the post is pretty old, but I believe it may help others |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-20 : 10:03:19
|
| We're dredging up 4 year old posts to advertise now? |
|
|
|
|
|
|
|
|
import .dbf data file