ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   importing data from access (https://www.excelbanter.com/excel-programming/348770-importing-data-access.html)

amrezzat[_18_]

importing data from access
 

hi guys
how can i import data form an database access file
and make the cells have that data??
please answer in details
thx


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=495571


Kevin B[_5_]

importing data from access
 
You can export an entire Access table to Excel, or create a query in Access
to filter what you want from the table, you can then save the query and
export the query to Excel.

Or, from Excel, run MS Query and query the data you want, or run a presaved
query.
--
Kevin Backmann


"amrezzat" wrote:


hi guys
how can i import data form an database access file
and make the cells have that data??
please answer in details
thx


--
amrezzat
------------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
View this thread: http://www.excelforum.com/showthread...hreadid=495571



amrezzat[_19_]

importing data from access
 

look
i cant change the access file
and there is another programe which is auomatically updated the acces
file it
so i want to know
specific information from that access file when it changed
and i paste it into the cells of excel fil

--
amrezza
-----------------------------------------------------------------------
amrezzat's Profile: http://www.excelforum.com/member.php...fo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=49557



All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com