Excel 2002 VBA connection to Access 2002 using SQL
 

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

Excel 2002 VBA connection to Access 2002 using SQL
 

See Mr. Erlandsen's site:
http://www.erlandsendata.no/english/...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

--
Regards,
Tom Ogilvy


"Pal" wrote in message
om...
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