No Cerveza... No Trabajo
Join Date: Jun 2002
Location: Where's my beer?
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 and check for import errors.