comcu
Jul 5th, 2006, 11:03 AM
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
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