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 Chriss Miller 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
Joined
Jul 22, 2008
Messages
2
Location
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

C
  • Locked
  • Question Question
foxpro to pdf
Replies
6
Views
1K
Chriss Miller
C
C
  • Locked
  • Question Question
Excel to Foxpro 2.6
Replies
19
Views
2K
brucewayne00100
B
A_Radiolog_inFoxPro
  • Question Question
FoxPro 6.0 project migration to python
Replies
7
Views
763
Pieter Koemans
Pieter Koemans
C
  • Locked
  • Question Question
foxpro print
Replies
4
Views
658
xWongso
xWongso
ajenat
  • Locked
  • Question Question
Include non-foxpro EXE within Foxpro EXE
Replies
5
Views
934
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top