Showing related tags and posts accross the entire site.
-
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...
-
Using Parameters In External ODBC Data Queries Here we can demonstrate the linking of data in an external data source with Excel, using the values in cells to determine the data presented, using parameterised data queries. Open a workbook and on the active sheet in cells A1 enter Start Date and in B1...