Excel 2002 VBA connection to Access 2002 using SQL

[Pal]

Hi,

I have problems linking from Excel 2002 VBA to Access 2002 using SQL.
Is there a sample code showing this?

Thanks in advance.

Palvannan

 

[Tom Ogilvy]

See Mr. Erlandsen's site:
http://www.erlandsendata.no/english/index.php?t=envbadac

probably want to use ADO (DAO is older and replaced by ADO)




http://support.microsoft.com/?kbid=295646
HOWTO: Transfer Data from ADO Data Source to Excel with ADO