I've posted this question on an Access workgoup. I get suggestions on alternative methods to use, but it doesn't answer my question.
I'm trying to import Access data that resides in tables into Excel using "Import External Data - New Database Query". The problem is when I select the tables, the fields do not show up except for 1 table.
I have 15 tables, most of which are lookup tables for 2 main tables. The two main tables are StoreInstall and LaneDetails. The StoreInstall table contains store information while the LaneDetails table contains the various types of lanes that can go into a store. There is a one-many relationship between StoreInstall and LaneDetails tables. Here's the problem, I can access the fields for LaneDetails but not the StoreInstall. Any help would be appreciated.
I'm trying to import Access data that resides in tables into Excel using "Import External Data - New Database Query". The problem is when I select the tables, the fields do not show up except for 1 table.
I have 15 tables, most of which are lookup tables for 2 main tables. The two main tables are StoreInstall and LaneDetails. The StoreInstall table contains store information while the LaneDetails table contains the various types of lanes that can go into a store. There is a one-many relationship between StoreInstall and LaneDetails tables. Here's the problem, I can access the fields for LaneDetails but not the StoreInstall. Any help would be appreciated.
