You have been asked to copy a one-table Access database to another table that exists in a SQL Server 7 database. What is the best method you should use to copy the data?

  1. The copy_db command at a command prompt

  2. Data Transformation Services

  3. The oslp utility

  4. Data Transfer System

  5. The BULK INSERT statement


Correct Option: B

Find more quizzes: