PDA

View Full Version : SQL Server 2000 help

Tiny Tim
05-02-2003, 08:58 AM
anyone know how to import a visual foxpro 7.0 free table into SQL Server 2000? Nothing really seems to work in DTS.
01WhiteCobra
05-02-2003, 09:31 AM
Create an ODBC entry for the database.

Create an empty table in SQL Server and right click it and select All Tasks->Import Data

From the wizard, select Visual Fox Pro Driver and select the ODBC entry you created.

Click next and make sure it says "Microsoft OLE DB Provider For SQL Server" as the Destination.

Click next and select "Copy tables from..."

Click next

Click next and check for import errors.
AbecX
05-02-2003, 09:45 AM
Originally posted by Tiny Tim
Nothing really seems to work...
;)
Tiny Tim
05-02-2003, 09:52 AM
Originally posted by AbecX
;)

yeah foxpro sux
Tiny Tim
05-02-2003, 10:08 AM
Originally posted by 01WhiteCobra
Create an ODBC entry for the database.

Create an empty table in SQL Server and right click it and select All Tasks->Import Data

From the wizard, select Visual Fox Pro Driver and select the ODBC entry you created.

Click next and make sure it says "Microsoft OLE DB Provider For SQL Server" as the Destination.

Click next and select "Copy tables from..."

Click next

Click next and check for import errors.

thanx got it to work, had to change the create table query to get it to work.