Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » VBA » ODBC (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Reading excel file with ODBC

    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...
    Posted to VBA (Forum) by Pgmer on Mon, Jul 7 2008
  • Re: ODBC reading excel file over internet

    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...
    Posted to VBA (Forum) by Pgmer on Mon, Apr 21 2008
Page 1 of 1 (2 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.