How to import DBF file in SQL2005

Hi,
It is easy to import .DBF file In Sql 2000.
But, How to import DBF file in SQL2005?
thanks.
bill
Can you explain how you do it in 2000?

> It is easy to import .DBF file In Sql 2000.
> But, How to import DBF file in SQL2005?
> thanks.
> bill
>
|||Hi Bill,
You can try this
How to: Connect to a dBASE or Other DBF File
http://msdn2.microsoft.com/en-us/library/aa337084.aspx
If you want to use the Import and Export Wizard maybe you want to import the
data to SQL Server 2000 first and then import this data from SQL Server 2000
to 2005. Or maybe import from DBF to Excel or Access and then use the wizard
to import to SQL Server 2005.
Hope this helps,
Ben Nevarez
Senior Database Administrator
"bill" wrote:

> Hi,
> It is easy to import .DBF file In Sql 2000.
> But, How to import DBF file in SQL2005?
> thanks.
> bill
>
>
|||> If you want to use the Import and Export Wizard maybe you want to import
> the
> data to SQL Server 2000 first and then import this data from SQL Server
> 2000
> to 2005. Or maybe import from DBF to Excel or Access and then use the
> wizard
> to import to SQL Server 2005.
Ben,
Do you think there might be drivers out there that work with DBF files in
2005?
There is a similar situation going on with SQL Server 2008, where Office
2007 is being ignored. You will need to install ACE OLEDB drivers after the
fact if you want the wizards to be able to understand Office 2007 file
formats.
Aaron
|||The link is from BOL for SQL Server 2005 and it is using the Microsoft Jet
4.0 OLE DB Provider on SSIS. At this moment I do not have any DBF file to
test it.
I also mentioned that the Import and Export Wizard can be used in a two step
process from DBF to SQL Server 2000 or Access or Excel and from there to SQL
Server 2005.
Regards,
Ben Nevarez
"Aaron Bertrand [SQL Server MVP]" wrote:

> Ben,
> Do you think there might be drivers out there that work with DBF files in
> 2005?
> There is a similar situation going on with SQL Server 2008, where Office
> 2007 is being ignored. You will need to install ACE OLEDB drivers after the
> fact if you want the wizards to be able to understand Office 2007 file
> formats.
> Aaron
>
|||OK!
Thank you very much!
bill
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> glsD:37B67CC1-2786-4E9C-AB6D-212BAEC69FA3@.microsoft.com...[vbcol=seagreen]
> Hi Bill,
> You can try this
> How to: Connect to a dBASE or Other DBF File
> http://msdn2.microsoft.com/en-us/library/aa337084.aspx
> If you want to use the Import and Export Wizard maybe you want to import
> the
> data to SQL Server 2000 first and then import this data from SQL Server
> 2000
> to 2005. Or maybe import from DBF to Excel or Access and then use the
> wizard
> to import to SQL Server 2005.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
>
> "bill" wrote: