import/export problem

[supernova122]

In SQL2000, when I do import/export, there is DBaseV in the destination. In
SQL 2005, there is such selection. How can I make DBaseV export in SQL 2005?
Thanks.

 

[supernova122]

Sorry. I mean there is no such selection in SQL 2005.

 

[AlexCuse]

If this is a quick fix, you can open dbase files in excel or access and save as a different format.

If it's something you'll be running a lot, you will need to search for a dbf driver for SQL 2005 (I do not know where to find this).

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[Babb]

Try this

SELECT *
FROM OPENROWSET('MSDASQL', 'Driver={Microsoft dBase Driver (*.dbf)};DBQ=<Directory>', 'Select * from <dbf filename>')