Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bring Over tables from Foxpro to SQL SERVER 1

Status
Not open for further replies.
bsembhi

bsembhi

MIS
Jul 22, 2008
2
US
Is there a way to to bring over tables from Foxpro to SQL SERVER without using DTS packages
 
Sort by date Sort by votes
I found the DTS packages very very slow importing from FoxPro to SQL Server. Finally, I wrote a small PRG file to export the data from the FoxPro table to a TXT file, and then built a DTS package to import from the TXT file to SQL. It also had the advantage that I could cleanse the data somewhat during the export.
 
Upvote 0 Downvote
You could use Excel if you are not concerned about memo fields .
You may have to break up large databases into chunks 16k records due to limits of exporting to excel.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CBellucci
  • Locked
  • Question
Retrieving Images (varbinary(max)) from MS SQL Server 1
Replies
3
Views
724
Chris Miller
Chris Miller
mmerlinn
  • Locked
  • Question
FoxPro button status
2
Replies
32
Views
2K
Scott24x7
Scott24x7
Dronner
  • Locked
  • Question
How to display photos from Visual Foxpro 6? 2
2
Replies
23
Views
630
sedenter
sedenter
ravicoder
  • Locked
  • Question
OCR with visual foxpro
Replies
3
Views
582
Gerrit Broekhuis
Gerrit Broekhuis
gbcpastor
  • Locked
  • Question
Export Foxpro 9 DBF to Dbase 5 File 1
2
Replies
22
Views
2K
Don Child
Don Child

Part and Inventory Search

Sponsor

Back
Top