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.
Re: Linking a database to excel vba
What kind of database are we talking about?
Re: Linking a database to excel vba
an access database which stores contact details.