Linking a database to excel vba

Hi

Using excel I’m trying to link a database to a ‘Adodc’ then show the data base on a ‘Datagrid’ I managing to link the database to the ‘Adodc’ thru ‘connection string’ & ‘record source’ this seems to be working fine.

My problem is that I cant get the database to show on the datagrid.

Ive have done it before using VB6.0. On the properties section of the datagrid was a box to select ‘data source’ this doesn’t seem to be on the VBA version in excel.

So how do you do it?

Thanks for your help.

Col

I've tried the office development section but no one has been able to help.

What kind of database are we talking about?

an access database which stores contact details.