Since Office Excel 2007 and its .xlsx extension came after a long time after SQL Server 2005 release and since this new format is entirely different from the previous formats we have a little problem in using Connection manager for Excel files option with Excel 2007.This was sorted out with the Service Pack 2. This Service Pack gave us a new driver which could be used for Office Excel 2007 files.
Here are the brief steps on how to create a connection manager for Excel 2007.
In a new or existing package,
1. Add a New Connection and choose the connection manager type either ADO.NET or OLEDB by right-clicking on the Connection Managers tab.
2. Click on New and under the Provider drop-down list, select Microsoft Office 12.0 Access Database Engine OLE DB Provider
3. Click OK 4. Click on “All” which is located on the left side of the connection manager window, and type “Excel 12.0” against the Extended Properties.
5. Now go back to the Connections tab and type in the file path of the Excel 2007 file along with the file name there. 
6. Click OK and you are done.
7. The same can be used for Access database 2007.
5 comments:
Really useful.
Manu
Thank you!
Mua vé tại đại lý vé máy bay Aivivu, tham khảo
vé máy bay đi Mỹ khứ hồi
vé máy bay từ mỹ về việt nam bao nhiêu tiền
vé máy bay từ đức về sài gòn
vé máy bay từ nhật về việt nam 2021
Các chuyến bay từ Incheon về Hà Nội hôm nay
vé máy bay từ canada về việt nam bao nhiêu tiền
khách sạn cách ly hà nội
ve may bay chuyen gia sang Viet Nam
You provide the informative information related to SQL 2005 and Excel 2007 in detail. Thank you for sharing with us. Further, If you want to get painting services for homes and offices, then I suggest you to hire painting contractors in Miami for best performance.
Those want to get about the SQL. They can teach at here easily. While, I am providing you cabinet refinishing manassas service. Its provide satisfaction to household family.
Post a Comment