472,353 Members | 1,824 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

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 1869

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

Similar topics

0
by: TheCoder | last post by:
I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields...
3
by: Omar | last post by:
Hi Developers, I am trying to access an Excel data file through a VB.Net application. I have the following code: ...
0
by: shapper | last post by:
Hello, I have a Connection String defined in my Web.Config: <connectionStrings> <add name = "dbAccess_JaquelineRoxoAtelier" connectionString...
0
by: shapper | last post by:
Hello, I created an Asp.Net 2.0 Access Data Source. Is it possible to loop the loaded records and access each record field value? Thanks, ...
1
by: Simon | last post by:
Dear Access friends, How can I load a string with his own folder address. The following code addressed to the system folder of MS programs.
3
by: D | last post by:
Hello everyone I have developed a web application using .asp to access a data source on a different server than where my .asp files are stored....
0
by: Helmut Kotsch | last post by:
Hi, this drives me crazy, 4 years ago I defined in an ACCESS 2000 application a "PivotTable-Form". The resulting EXCEL table inclusive the...
7
by: semijoyful | last post by:
OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on...
6
by: Chip Pearson | last post by:
I'm sure I'm missing something simple, but I've hit a brick wall. I'm creating an ASP.NET 2.0 web site in VS2005 (VB.NET) and need to read data...
3
by: duyanning | last post by:
I have written a pyhton script that will process data file in current working directory. My script is in an different directory to data file. When...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.