February 7, 2007 at 10:00 pm
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.
February 7, 2007 at 10:25 pm
Sorry. I mean in SQL 2005, there is no such selection at all.
February 7, 2007 at 11:29 pm
For some reason they removed...no idea why... you may try exporting into excel and convert excel into dbase/faxpro...
Just google for "excel to dbase convertion"
MohammedU
Microsoft SQL Server MVP
February 8, 2007 at 5:22 pm
There is a dbt file when doing import/export in sql2000 which I need. But if I do it with excel, then the dbt file cannot be generated. PLease help. Thanks.
February 9, 2007 at 11:46 am
The import/export wizard doesn't support DBase files, but Integration Services does. You can export to dbase files using the OLEDB provider for Jet 4.0 in SSIS.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply