ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   EXCEL SQL.REQUEST of ACCESS DATA (https://www.excelbanter.com/excel-programming/444843-excel-sql-request-access-data.html)

[email protected]

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]





GS[_2_]

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




All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com