transferring data from Foxpro .dbf to SQL 2005

microsoft.public.sqlserver.tools

23 Jan 2006 6:32 PM

Tony

Hi,

Does anyone know of a quick method to data from a Foxpro database to SQL
2005.

Tony.

23 Jan 2006 7:18 PM

Cindy Winegarden

Hi Tony,

Be sure you have the latest FoxPro and Visual FoxPro ODBC drivers or OLE DB
data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates.

You could import your data using SQL 2000's DTS or SQL 2005's SSIS (SQL
Server Integration Services) packages.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegar***@msn.com www.cindywinegarden.com

Show quote

"Tony" <tbrijp***@miovision.com> wrote in message
news:%23kq%23mtEIGHA.740@TK2MSFTNGP12.phx.gbl...
> Does anyone know of a quick method to data from a Foxpro database to SQL
> 2005.