Help! I am trying to move a table containing about 8.5 million records from SQL 7 to Access 97 using the DTS Export Wizard. The export successfully creates the table, but only as far as record 3220000. SQL 7 then hangs up although it appears to be functioning normally. I have also tried using a text file as an intermediary, but Access doesn't seem capable of importing text files that large. Any suggestions?
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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using DTS to move table from SQL 7 to Access 97 1
- Thread starter tanuki3
- Start date
- Status
Similar threads
- Question
