Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing location of datasource

Status
Not open for further replies.
flaviooooo

flaviooooo

Programmer
Joined
Feb 24, 2003
Messages
496
Location
FR
Hi

I have a problem in Excel 97. I made a lot of Queries (with MS Query) on my local machine. But I had also copied the Datasource file (a DBF file) to my local drive. Now when I copied the excel-workbook to the network location where it has to work from; it fails to find the datasource. It still searches on my C-drive.

Is there any way to change the location of the datasource?

PS I've tried ODBC-definitions via control panel, but that didn't work either...
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Use 2 columns in Detail Section of report
Replies
8
Views
1K
TrekBiker
TrekBiker
D
  • Locked
  • Question Question
How can i have more than 1 line in the body of an email
Replies
2
Views
707
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
1K
bs6600
bs6600
remeng
  • Locked
  • Question Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
767
remeng
remeng
Rick_Stanich
  • Locked
  • Question Question
Save active Excel file to new location
Replies
6
Views
645
Rick_Stanich
Rick_Stanich

Part and Inventory Search

Sponsor

Back
Top