SQL Server 2000 help - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 5 (permalink) Old 05-02-2003, 07:58 AM Thread Starter
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
SQL Server 2000 help

anyone know how to import a visual foxpro 7.0 free table into SQL Server 2000? Nothing really seems to work in DTS.
Tiny Tim is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 05-02-2003, 08:31 AM
No Cerveza... No Trabajo
 
01WhiteCobra's Avatar
 
Join Date: Jun 2002
Location: Where's my beer?
Posts: 21,924
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.
01WhiteCobra is offline  
post #3 of 5 (permalink) Old 05-02-2003, 08:45 AM
¯\(º_o)/¯
 
AbecX's Avatar
 
Join Date: Nov 2001
Location: Las Colinas
Posts: 25,373
Re: SQL Server 2000 help

Quote:
Originally posted by Tiny Tim
Nothing really seems to work...
AbecX is offline  
 
post #4 of 5 (permalink) Old 05-02-2003, 08:52 AM Thread Starter
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Re: Re: SQL Server 2000 help

Quote:
Originally posted by AbecX
yeah foxpro sux
Tiny Tim is offline  
post #5 of 5 (permalink) Old 05-02-2003, 09:08 AM Thread Starter
Timmay
 
Tiny Tim's Avatar
 
Join Date: Aug 2001
Posts: 4,898
Quote:
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.
Tiny Tim is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome