QueryTables equivalent in Access 2002?

K

k1

Anyone?
I have a vba routine in excel that queries data from a unix server with
using a connection string. I’m using the get external web functionality in
excel. Since I hit the 65K barrier in excel, I’m hoping to do this in
Access.

How might I go about importing this data into access?

Sample that downloads data into IE window:
http://myunixserver.mydomain.com:8080/mysite/jsp/SQLOutput.csv?WireCenterID=nlf&sqlstring=SELECT * FROM tprda&database_type=lead

Excel vba code that downloads same data into spreadsheet:
Sub GetWebData() 'queries data from ingres unix dbase
Dim sqldata As QueryTable

Set sqldata = ActiveSheet.QueryTables.Add( _
Connection:="TEXT;" &
"http://myunixserver.mydomain.com:8080/mysite/jsp/SQLOutput.csv?" & _
"WireCenterID=nlf" & "&database_type=lead&" & _
"sqlstring=SELECT * FROM tprda", _
Destination:=Range("A1"))

With sqldata
.TextFileStartRow = 7
.TextFileCommaDelimiter = True
.Refresh BackgroundQuery = True 'executes the retrieval and dumps
external data to activesheet
End With
End Sub
 
Top