I just tried to apply the foxpro driver VFPOLEDBSetup.msi to import and export an old format dbf.
First of all no other method is available in this case, asÃÂ one of the dbf-tablesÃÂ holds about 9 million rows.
I don't want to (manually) go to excel and wait for 10 years importing it there, then only to discover i need another
10 years to get it into sql server.
Here's my task at hand:
Source: street/housenumber database with approx 9 million rows
Task:ÃÂ Convert it to SQL server database (import DTS)
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ Change some data
Export it back to DBF format.
I don't have any problems acting on the first two steps (dts import to SQL 2k5 and changing data)
I doooo have some problems with the last part.
As soon as i define the DTS through the wizzard, it leaves the "CodePage" blank.
However, upon executing it i receive some warnings and finally errors:
On the "Setting Destination Connection" action in the final execution progress window:
- Setting Destination Connection (Warning)
Warning 0x80202066: Destination - housenum : Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the co
View Complete Post