Import wizard to import Microsoft Excel 2007 file to SQL Server 2005
Posted on 2011-03-04
Currently I have been using Microsoft Excel 2003 at my work and I am importing the data from Excel file to SQL Server 2005 database by using the import wizard where I choose Excel as the data source. However, I am planning to upgrade the Excel to 2007 version. How would I import Excel 2007 into SQL Server? Can someone walk me through.
Secondly, would all my SSIS break (in case the Excel files are upgraded to 2007, i.e .doc to .docx) where I am using the script task and VB.NET to access the Excel with a code something like this:
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=" + filename + "', 'SELECT * FROM [" + SheetName + "$]')