| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
| wanna use print preview in excel 2002 without printer connection | Excel Discussion (Misc queries) | |||
| MS Access Database Connection problem in Excel XP 2002 | Excel Programming | |||
| ado connection string for excel 2002 | Excel Programming | |||
| Excel 2002 files attached to Outlook 2002 EMails change size | Excel Programming | |||
Hybrid Mode
