database integration

[Killa]

How do i specify an object as a database with vba in excel.

this is the line i expect would normally use

dim dbinfo as database



Unfortunately i can not find the "database" type available

I am trying to use excel to update a access data base but the users will not have access

ANY help will be greatly appreciated

 

[TonyJollans]

Make sure you have a refernce to the appropriate library, DAO, I think it is:

In Tools > References, check "Microsoft DAO [version] Object Library"

Enjoy,
Tony