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 |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2004-12-03 : 14:00:44
|
| Hi, I am trying to DTS foxpro file to SQL server thru dBase ODBC connection. I am getting Microsoft Jet database engine error. External file is not in expected format. If I use foxpro connection I am getting invalid status for data bound error. Any help on this very much appreciated.thanks |
|
|
AlDragon
Starting Member
12 Posts |
Posted - 2004-12-06 : 23:09:26
|
| Are you using dbase 5,IV or III as the data source? Did you install service pack 2 on your machine?Al Franzini |
 |
|
|
thanksfor help
Posting Yak Master
106 Posts |
Posted - 2004-12-08 : 19:06:26
|
| I use dbase 5,IV. Can I have more detail about service pack 2. Because I don't know how to check for it my machine.Thanks |
|
|
|
AlDragon
Starting Member
12 Posts |
Posted - 2004-12-10 : 13:27:10
|
| If you have Foxpro installed on your machine open the dbase file in foxpro and type this in the command window.copy to newtablename foxpluswhere ever the file is located is where the newtablename will be placed. Try importing the new dbase file.Al |
|
|
|
mprolli
Starting Member
24 Posts |
Posted - 2004-12-10 : 13:30:13
|
| Open the foxpro file in VS and save it as a Dbase2x file, then try to reimport it.Let us rise up and be thankful, for if we didn't learn a lot today, at least we learned a little, and if we didn't learn a little, at least we didn't get sick, and if we got sick, at least we didn't die; so, let us all be thankful. --Buddha |
|
|
|
|
|
|
DTS help