View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.