Can Excel be linked to MS Acess?
You need to do a database query. In excel go to the following menu
Data - Import External Data - New Database Query
Choose MS Access Database. Then use Browse to get to you database file.
"Madhart" wrote:
I'm taking a shot in the dark here but can MS Acess be linked to an Excel
worksheet? At work we use Acess(gatelog) to track people in and out. We
then transfer those times for people manually to an Excel worksheet. Is
there any (hopefully easy) way to link the two so the Excel worksheet is auto
updated with all the same information? If so how would I go about that and
what all would need to be involved?
Thanks.
|