469,347 Members | 15,465 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,347 developers. It's quick & easy.

excel access data source = current folder or directory

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
0 1672

Post your reply

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

Similar topics

reply views Thread by TheCoder | last post: by
reply views Thread by shapper | last post: by
6 posts views Thread by Chip Pearson | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.