Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Washington D.C.

    Unanswered: Bulk insert from Access to SQL Server

    Can anyone give me some advise on how to do a bulk insert into an SQL Server DB from Access using DTS.

  2. #2
    Join Date
    Feb 2003
    if you currently have data in the table try makeing a copy of the table and practice importing into that. just use the wizard and when you get to the select source table and view take time to look in the transforms and all the tabs. perhaps you should check the enable identity insert.
    best way to learn it is to practice it a few times.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts