Jun 10 2004, 11:58 PM
Does anyone know how to set up an ODBC link to a web site? The files are saved in a cgi bin on the web site in excel format, and i want to import or link it into Access. So if anyone has ideas or links that i can read it will help, Thanks.....
Jun 11 2004, 12:13 AM
ODBC doesn't work over a network unless you can reach the destination as a "share" within Microsoft's operating system. That is, the destination file appears to be on a local drive letter to you.
If this is your web server then perhaps you can make a share but this is considered a risky venture (from a security point of view) if that web server is connected to the Internet.
You might be able to use ftp to transfer the file but that depends on whether the webserver is also an ftp server.
In short, this is difficult to do. Is the webserver or web site under your control?