📚 Practice Mode

technology Online Quiz - 1841

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Choice

What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?

  1. Excel Connection Manager with Excel version 2007
  2. Microsoft Jet 2007 OLE DB Provider
  3. Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0
  4. File Connection Manager
Change Mode