ADODB over HTTP?
 

Hi,

I've currently got an ADODB connection to a CSV file on a fileserver
working over TCP-IP. My VBA looks something like this:

fname = "\\fileserver\directory\file.csv"

With resultLocation.Worksheet.QueryTables.Add(Connectio n:="TEXT;" &
fname, Destination:=resultLocation)
.attributes = blah
End With

However, the production of our CSV files is now automated as a cron
job on an AIX box and the only feasible way to access them (between
platforms) is accross HTTP. Can I get excel to easily connect over
this protocol, i.e. making my string filename string more like:

fname = "http://internal.server/directory/file.csv"

My first attempts have failed miserably - is this idea going
anywhere?

Thanks,
Louis

ADODB over HTTP?
 

What about using a web query ?

NickHK

"LDB" wrote in message
oups.com...
Hi,

I've currently got an ADODB connection to a CSV file on a fileserver
working over TCP-IP. My VBA looks something like this:

fname = "\\fileserver\directory\file.csv"

With resultLocation.Worksheet.QueryTables.Add(Connectio n:="TEXT;" &
fname, Destination:=resultLocation)
.attributes = blah
End With

However, the production of our CSV files is now automated as a cron
job on an AIX box and the only feasible way to access them (between
platforms) is accross HTTP. Can I get excel to easily connect over
this protocol, i.e. making my string filename string more like:

fname = "http://internal.server/directory/file.csv"

My first attempts have failed miserably - is this idea going
anywhere?

Thanks,
Louis

ADODB over HTTP?
 

On 15 Jun, 05:01, "NickHK" wrote:
What about using a web query ?

NickHK

"LDB" wrote in message

oups.com...

Hi,

I've currently got an ADODB connection to a CSV file on a fileserver
working over TCP-IP. My VBA looks something like this:

fname = "\\fileserver\directory\file.csv"

With resultLocation.Worksheet.QueryTables.Add(Connectio n:="TEXT;" &
fname, Destination:=resultLocation)
.attributes = blah
End With

However, the production of our CSV files is now automated as a cron
job on an AIX box and the only feasible way to access them (between
platforms) is accross HTTP. Can I get excel to easily connect over
this protocol, i.e. making my string filename string more like:

fname = "http://internal.server/directory/file.csv"

My first attempts have failed miserably - is this idea going
anywhere?

Thanks,
Louis


Nick,

I've tried using a web query (i.e. connection:="URL;...") but then it
doesn't split the file by the delimitation character specified! It
ends up dumping the whole line (e.g. 234,34545,4444) in one cell...

Any thoughts??

Louis

ADODB over HTTP?
 

Apply dataText To Columns after.

NickHK

"LDB" wrote in message
oups.com...
On 15 Jun, 05:01, "NickHK" wrote:
What about using a web query ?

NickHK

"LDB" wrote in message

oups.com...

Hi,

I've currently got an ADODB connection to a CSV file on a fileserver
working over TCP-IP. My VBA looks something like this:

fname = "\\fileserver\directory\file.csv"

With resultLocation.Worksheet.QueryTables.Add(Connectio n:="TEXT;" &
fname, Destination:=resultLocation)
.attributes = blah
End With

However, the production of our CSV files is now automated as a cron
job on an AIX box and the only feasible way to access them (between
platforms) is accross HTTP. Can I get excel to easily connect over
this protocol, i.e. making my string filename string more like:

fname = "http://internal.server/directory/file.csv"

My first attempts have failed miserably - is this idea going
anywhere?

Thanks,
Louis


Nick,

I've tried using a web query (i.e. connection:="URL;...") but then it
doesn't split the file by the delimitation character specified! It
ends up dumping the whole line (e.g. 234,34545,4444) in one cell...

Any thoughts??

Louis