Originally posted by z9962Ok I have just had a look for you, see how this goes...
Create a new connection
Select OLE DB (ADO)
Select the Microsoft Office 12.0 Access Database Engine... Provider
Change the Office Database type to Excel
Select the data source.
Leave userId Password etc as is.
That should work, I have not used in the past, but did a quick test and seems to be working of for me.
How timely. I was just working out this same issue. I tried this connection method and it worked.
IP Logged
