Linking to 192.168.10.5/something.csv

[CheguTom]

Hi
I have a remote sensor residing at an ip address and can reach by browser at http://192.168.10.5/data/output.csv

I would like to open it as a text file or import it into a database using VBA code.

How do I reference it. I tried

Open http://192.168.10.5/data/output.csvfor input as #1

What am I missing?

I would also be happy to import it to a local table or link to it

Thanks



Tom

[ajetrumpet]

why not download it, then import it with the wizard?

[CheguTom]

Hi

I can download and import with the wizard. I would have to do that every day!

I want to automate the process with code

Thanks

[ssanfu]

Seems to me that you should be able to map that address/folder to a drive letter.

192.168.xxx.xxx tells me that you have a LAN. Map that address to a drive letter, then use the drive letter in your code. You would have to have the path to the "/data" folder shared.

Just an idea.....