Need help linking excel to database

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