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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing tables into SQL 7- DTS lockup

Status
Not open for further replies.
gsforce

gsforce

Programmer
Mar 11, 2000
5
US
I final got my system running SQL (win 98/Website). But when I try to import a database (Access) the DTS get to the 'finished' step and locks up the enterprise manager when I click on the finish button. Everything else appears to be working OK.
 
Sort by date Sort by votes
Make sure that you are using the most recent Access Driver for your access version.<br>I get the same thing when I tried to import data from Visual FoxPro to SQL 7.0&nbsp;&nbsp;using DTS and it turned out that the problem was caused due to a bug in the FoxPro driver.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
1K
Chris Miller
Chris Miller
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
706
pjw001
pjw001
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
797
Chris Miller
Chris Miller
Steve Yu
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
326
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top