Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default EXCEL SQL.REQUEST of ACCESS DATA

What is the exact syntax for something like

=SQL.REQUEST(c:\dog.mdb,Select tag from dog where paw=a2)

All the refs I've seen are too confusing with mutliple references to
the database and so on.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default EXCEL SQL.REQUEST of ACCESS DATA

explained :
What is the exact syntax for something like

=SQL.REQUEST(c:\dog.mdb,Select tag from dog where paw=a2)

All the refs I've seen are too confusing with mutliple references to
the database and so on.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.panix.com/~vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Phooey on GUI: Windows for subprime Bimbos]


Here's a good place to start...

http://www.appspro.com/conference/Da...rogramming.zip

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


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
"Looking Up" Access from Excel using SQL.REQUEST Duncan Davies Excel Worksheet Functions 5 April 12th 06 01:38 PM
Access to Excel using SQL.REQUEST Duncan Davies Excel Discussion (Misc queries) 0 April 6th 06 05:29 PM
Request to access the Internet donbowyer Setting up and Configuration of Excel 2 March 23rd 06 01:26 PM
Knowledge gained from Access to Excel VBA Automation User request ImraneA Excel Programming 0 January 29th 04 04:35 PM
sql.request for secured Access Database record retrieval Theo Fountain Excel Programming 0 July 17th 03 08:14 PM


All times are GMT +1. The time now is 01:46 AM.

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"