Data connection between Excel sheets

M

markjg

I am trying to connect to an Excel spreadsheet from another spreadshee
(also from Sharepoint trying to pivot an excel sheet).

Below is the data source connection I have made, but it only works i
the Excel spreadsheet I am connecting to is OPEN, if not it cannot fin
the object and returns no data. Any ideas?

Provider=MSDASQL.1;Persist Security Info=True;Extende
Properties="DSN=Exce
Files;DBQ=I:\MGregory{KPIDataFiles}\KPIGraphs2.xls;DefaultDir=I:\MGregory{KPIDataFiles};DriverId=790;MaxBufferSize=2048;PageTimeout=5;";Initia
Catalog=I:\MGregory{KPIDataFiles}\KPIGraphs
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection files and pivot tables 0
Query Tables (excel odbc) memory problem 0
Use MS Query to query data within the current work book 0
Pivot Chart OWC sourced from Excel 0
2002 excel isn't playing well with 2007 1
Excel getting info from Access 1
Importing from Excel using a connection string? 0
Refresh Excel Sheet with Access Data Frequently 0

Top