-
I am trying to use ODBC to read a closed spreadsheet. The code that I am using (see below) works, but instead of just reading the data, it is actually opening the file and reading the data. I do not understand why or how. Any ideas would be greatly appreciated. Here is the code: Public Function read_table...
-
The code is currently opening the file as you describe. The main reason we are implementing this code is for speed reasons. Based on that, I am trying to find the absolute fastest way to read this data. I had done some testing on my local PC and known network locations (with regular drive letters), and...
-
Nick, I know the 'best' way to go would be to get the full share name. However, due to security reasons, I won't be able to get that (not to mention that they want to be able to move the web server to a different server at any time). Therefore, I cannot use the full share name. The links...
-
The data in the external spreadsheet is controlled by someone else, and when they update it, they post a copy on our intranet. It would be difficult, at best, to train them to save it as an HTML type file (I believe I could do the same with CSV, but have the same user difficulty). In addition, I am using...
-
In theory it should work, but why not use a web query, Data>External Data>New web query... Once set up you can just refresh as the data changes. This will need the data saved as HTML, or some other web technology, but HTML is a native format in 2003, so that should be no issue If you wish to persevere...