hadi98
asked on
Importing Data from Access to Excel
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
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
ASKER
Dear Elbie,
Thanx for yor comment,
I use the ODBC and Microsfyt Query becuse I want to dispaly data from more than one Query wich I can't do it using TransferSpreadSheet command
and I don't knowif I can do it using VBA in Excel
pleas How I can display data from more than one query in one SpreadSheet
Thanx for yor comment,
I use the ODBC and Microsfyt Query becuse I want to dispaly data from more than one Query wich I can't do it using TransferSpreadSheet command
and I don't knowif I can do it using VBA in Excel
pleas How I can display data from more than one query in one SpreadSheet
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
- Answered by: elbie
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
Comment from expert accepted as answer
Computer101
E-E Admin
Computer101
E-E Admin
That's true; using the ODBC wizard to do what you want is generally not a good idea. Use VBA in Access or Excel to accomplish the same thing using the TransferSpreadSheet command. You can also just link the sheet as if it were a table in the Access database, then copy both to another computer relink the Excelsheet and you're done. That last option is by far the easiest way to go about it, no ODBC needed!
Hope this helps,
Elbie.