SQL Server Performance Forum – Threads Archive

Import dbase IV to SQL Server 2k sp3

Hi All,<br />I have a problem importing dbf file (dbase IV) using ODBC or OLE DB, everything works fine with both drivers except when there is a column with numeric datatype and decimal point is specified for ex. DataType: Numeric, Size: 6, Dec: 3 I used DBF Viewer to see the data type etc. SQL Convert numeric(6,3) to float(<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> but no data in the field just 0 (zero) MS Access done the same shows everthing but numeric(6,3). I also tried with ADO.Net and simple select statement just to get a data out of the numeric column no luck.<br />Note other Numeric columns are fine as long as no scale or decimal point specified.<br />Help please my project is to work with this database using ms .net<br /><br />mabb

---

Is this a one time event, or will you be importing data from dBase IV to SQL Server often? Also, does this have to be done through ODBC or OLE DB, or can it be done through SQL Server DTS? The reason I ask is that SQL Server DTS is the easiest way I have found to import data into SQL Server. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

I will be importing to sql server often, Yes I have to use ODBC or OLE DB, I tried SQL Server DTS every thing work but the Numeric datatype with decimal point.
mabb

---

Ensure correct version of VFP driver is used in the DTS while importing the data.
Check the DTS package log for more information on package execution. In your case scheduling the DTS job will accomplish the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>