title: Trying to Load Data from Excel into SQL Server. 32-bit Excel and 64-bit SQL Server Throws Error
body: <p>I've tried a few different ways to load data from Excel into SQL Server, as shown here:</p>
  
  <pre><code>Use [TestDatabase]
  
  SELECT * 
  INTO dbo.tbl_SST_Personnel
  FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
         'Excel 12.0 Xml;HDR=YES;Database=C:\Users\rshuell001\Desktop\DATA - INPUT FILES\STT_Personnel.xlsx',
         'SELECT * FROM [tbl_SST_Personnel]')
  GO
  
  insert into OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Users\rshuell001\Desktop\DATA - INPUT FILES\STT_Personnel.xlsx;', 'SELECT * FROM [tbl_SST_Personnel]')
  
  select * from tbl_SST_Personnel
  
  Insert into tbl_SST_Personnel 
      Select * 
      FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users\rshuell001\Desktop\DATA - INPUT FILES\STT_Personnel.xlsx;HDR=YES', 'SELECT * FROM [tbl_SST_Personnel]')
  </code></pre>
  
  <p>I keep getting this error message for the first 2 scripts.</p>
  
  <blockquote>
    <p>Msg 7438, Level 16, State 1, Line 13<br>
    The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.</p>
  </blockquote>
  
  <p>The 3rd script throws this error:</p>
  
  <blockquote>
    <p>Msg 7302, Level 16, State 1, Line 14<br>
    Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".</p>
  </blockquote>
  
  <p>Any idea how I can get this working?</p>
  
  <p>Thanks to all.</p>