EXCEL SQL.REQUEST of ACCESS DATA

V

vjp2.at

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]
 
G

GS

(e-mail address removed) 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/DatabaseProgramming.zip
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web Queries? 1
Which unzip best for 6GB 1
5.3GB csv 6
Any other ways to use excel fcts in Access SQL 1
Move MyDoc vs SharedDoc 3
del * from x where zip < 14500 3
Excel fcts in Access 1
Call ext db from/in 2

Top