By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,852 Members | 1,014 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,852 IT Pros & Developers. It's quick & easy.

excel access data source = current folder or directory

P: 5
hi
I have created a data link from access query to excel. I use excel pull data from access in order to do stats. the excel workbook always stays in the same folder as the access db. I want to be able to copy the folder from one pc to another and keep the data connection from access to excel within the same folder. I looked for way to do this in the ODC file but aren't having any luck.

In the Connecting string(in excel data connection) it has the following: - Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=D:\Elize\Prospective Case Study\Prospective Case Study.accdb;Mode=Read;......-

I thought i could modify the section that says "Data Source =D:Elize......" from specifying a file path to something that suggests "current folder or directory"

is there a way of doing this?

thanks

trevor
Jun 2 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.