How do I Converting DBF database files to SQL Server 2005 in one step

[fever]

Hi,

At the moment i am converting the files in MS Access then using the SSIS wizard to covert the access files to Server files. This is not very practical for me and I was wondering is there another way to import dbf datafiles.

[ck9663]

Hi,

At the moment i am converting the files in MS Access then using the SSIS wizard to covert the access files to Server files. This is not very practical for me and I was wondering is there another way to import dbf datafiles.

You can use the DTS Wizard to import a DBF file directly.

-- CK

[fever]

Isn't the DTS wizard the same as the SISS but older ?

[ck9663]

Sorry, I'm not into terms.

Right-click your database. Choose Task. Choose Import Data. On the SQL Server Import and Export Wizard,choose the driver for Visual Foxpro....

then follow the instructions...

-- CK

[fever]

sorry for the long delay i had to reinstall server....


i presume by driver you mean data source... well that is not a option in my list...

[ck9663]

Am suggesting you use the SQL Server Management Console, not Access. What version of MSSQL are you using?


-- CK

[fever]

2005. I have got the tables into server by creating a connection to ODBC and then creating a dbase III datatype. its showing all of the tables but now i have no idea how to add them to the database

[fever]

i have been investigating further and it looks like the easiest method for doing this i must have Visual FoxPro ODBC Driver how do i get hold of that its not on Microsoft's website anymore

[ck9663]

If you choose that as your source data in sql 2005, it's already built-in

-- CK

[fever]

i got it to work with the odbc driver from the foxpro website and had a problem with the datetime field. Then i realised the files i am converting are not foxpro they are dbase III i didn't realise there was much of a difference