Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Opening a Database from Excel

Hi,

Is there any simple method of opening a Access DB and
running a query from the database from an Excel sheet?

Thanks

B
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Opening a Database from Excel

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

for using ADO.

--
Regards,
Tom Ogilvy

"Bhavini" wrote in message
...
Hi,

Is there any simple method of opening a Access DB and
running a query from the database from an Excel sheet?

Thanks

B



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Access database davethewelder Excel Discussion (Misc queries) 0 March 17th 08 05:17 PM
opening access database using macro rtphilips New Users to Excel 3 October 20th 05 05:11 PM
Slow opening database Shirley Excel Discussion (Misc queries) 0 September 20th 05 06:19 PM
opening and viewing an access-database Peer Excel Programming 2 July 28th 04 07:38 PM
Problems opening Access database from Excel VBA Jan[_11_] Excel Programming 3 June 2nd 04 12:08 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"