![]() ![]() ![]() Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. I also have Building Excel connections with a Component Tray which you set up the connection string in a property window and can test it out easily. If IO.Path.GetExtension(FileName).ToUpper = ".XLS" Thenīuilder.Provider = ".4.0"īuilder.Add("Extended Properties", "Excel 8.0 IMEX=1 HDR=No ")īuilder.Provider = ".12.0"īuilder.Add("Extended Properties", "Excel 12.0 IMEX=1 HDR=No ") Public Function ConnectionString(ByVal FileName As String) As Stringĭim Builder As New OleDb.OleDbConnectionStringBuilder You might need to change IMEX and/or HDR. If you have other versions of the Power Pivot add-in installed, those versions are also listed in the COM Add-ins list. Check the Microsoft Office Power Pivot box, and then click OK. In the Manage box, click COM Add-ins > Go. The idea is I can pass in a xlx or a xlsx. Here’s how you enable Power Pivot before using it for the first time. Even thou you indicated trying OleDb see if the following might work. ![]()
0 Comments
Leave a Reply. |