Posted to microsoft.public.excel.programming
|
|
Using Access data in Excel
This might help:
http://support.microsoft.com/?id=244761
Regards
Rowan
dok112 wrote:
Hello,
I have a Access database, CARS.mdb, and an excel file, CARS_SURVEY.xls.
Inside of CARS_SURVEY.xls there is a form. It has an ongoing
connection to the CARS.mdb database. Is there a way I can tell the
form to use the database table 'Shops' and colomn 'Shop_ID', for a drop
down inside the form on CARS_SURVEY.xls?
Ex.
CARS.mdb has a table, Shops and inside Shops is 3 colomns. I want the
colomn 'Shop_ID' to be used as the list source for the dropdown list,
Shop_ID on the form CARS in the excel file CARS_SURVEY.xls...
Any help provided is greatly appreciated!!
|