Hi, This is my first qustion in Expert Exchane And I hop I will get the solution from my frinds here.
I want to get data from my data base which in Access file to my Sheet in the Excel file.
I use the folowing method make the linke.
Firest: In Excel i select data/ Import ExternalData /New Data Base Query
Then: I creat Select the data source from the ODBC
After That I selct the database and creat My Microsoft Query and save it.
Evrey thing is Ok
Now I want to copy my Excel file and my Access file to Another Copmuter
the problem is that when I Refresh the Excel sheet the a massge said
" Microsft Access ODBC Driver could not find the file 'my fie Path'"
even when I go to thte ODBC and changr the datasource confgation to the new path of my Darabse the massge diaplayed .
I found that Excel file is linked to the first databas so I have to put my databse in th same path when I chage the copmuer