excel front end with Access backend

[uclabruin99]

Hi,
Can anyone tell me how to connect a Excel Workbook 2000 with a Access 2000 db? I am new to the field...need help.
I have various tables in the Access db from which I need to extract data as well. I really would appreciate some advice. Thanks.

 

[ETID]

ODBC...

in a blank excel worksheet, from the menu...

Data>get external data>new database query...follow the wizard, or select the use MS query option,...carefully select options you want on each window,...such as "read only" check boxes and what not...
then return data to ms excel.

when the data is returned, you can right click in the data area and set properies such as refresh on open


now when ever the database is updated the workbook will reflect the changes.(if you refresh...auto or manually)

 

[uclabruin99]

Thanks for your answer...i am doing that now. I got another issue lurking. I put a combo box (drop-down kind) on my excel sheet. The source of that combo box should be a Access 2000 table called tblProducts. What do I do?
What code do I need to write in VBA?

Can't seem to get thru this hoop.
I am so happy someone replied.

Thanks.

Angela
UCLA BRUIN 99

 

[ETID]

A dirty way, but it'll work,...

on seperate sheet

use the same proceedure as described above...

point it to your table called tblProducts, return only the column that you want in your list/combo box...then link your the box to that range.

 

[uclabruin99]

yikes...my co-workers want to have where they can just update that field in the access table and boom the changes take place in excel's combo box...so if tblProducts change then it not a big deal.

Any ideas?
Linked sheets are not allowed. Thanks for your help. Can't tell you how much I need it.

angela

 

[ETID]

Are you saying you cannot use the odbc connection described above?