Link Excel Tables in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have linked Excel pages into Access. I need to create another Access
database that's linked to the Excel pages in my other database. When I create
a knew database and attempt to link tables to my other database that contains
the linked Excel tables, I cannot see them. I need to be able to this so that
more than one user can access the database on the same time.
 
You can't link from the second .mdb file to linked tables in the first
..mdb file. Instead, have the second .mdb file link directly to the Excel
sheets.
 
Thanks John. But won't that give me the same problem with only having one
user access the original db? i'd like to have mutiple users access the same
table.
 
Yes, there are problems with providing shared simultaneous access to
data in a worksheet. Given all the other disadvantages of Excel as a
database management system, I've never tried to master them.
 
Back
Top