Windows 10: Set up a Network Directory a an ODBC Data Source for Excel Files

Discus and support Set up a Network Directory a an ODBC Data Source for Excel Files in Windows 10 Drivers and Hardware to solve the problem; I have a folder on a network drive in which I download Excel files produced by other reports and "data dumps." These Excel Files are used, in turn,... Discussion in 'Windows 10 Drivers and Hardware' started by DanFlak, Aug 13, 2020.

  1. DANFLAK
    DanFlak Win User

    Set up a Network Directory a an ODBC Data Source for Excel Files


    I have a folder on a network drive in which I download Excel files produced by other reports and "data dumps."


    These Excel Files are used, in turn, by my own reports. sometimes connecting to them by MS-Query.


    What I would like to do is set this directory up as an ODBC Data source, so I can navigate to it and then select the Excel file as I would a table from another database.


    I know that it is possible to set up a directory as an ODBC source for text files and I've done that in the past.


    I doubt that it is possible to set up a directory as an ODBC source for Excel Files, but I have to ask. It would be just too convenient to do this :.

    :)
     
    DanFlak, Aug 13, 2020
    #1
  2. BRENDANHEMENS1
    BrendanHemens1 Win User

    File DSN are slow to scan when opening ODBC Data Source Administrator

    *Sigh* I swear I spent an hour googling. I figured it out myself. To describe the symptom again:

    • If you open the ODBC Data Sources Administrator, and it is very slow to load the File DSN tab (e.g., a few minutes), and/or if when you select an ODBC export from Microsoft Access, and Access becomes unresponsive for a few minutes before opening the ODBC
      connection window, then...
    • Your File DSN directory may not be set. The default is a location in Program Files; mine was scanning my Documents directory, which is huge. I don't know why it was set that way. Anyway, I set it to an empty local folder (I never use File DSN), and now
      it opens lickity-split.
     
    BrendanHemens1, Aug 13, 2020
    #2
  3. KIERANATHERTON
    kieranatherton Win User
    How to installing Microsoft Excel Driver for ODBC data source (64bit)

    HI

    I want to add a new ODBC data source but when I go to add it the Microsoft excel driver isn't there?


    Set up a Network Directory a an ODBC Data Source for Excel Files 466a2610-3ab4-4661-979c-7194b253beca?upload=true.jpg
     
    kieranatherton, Aug 13, 2020
    #3
  4. MESPIA
    MesPia Win User

    Set up a Network Directory a an ODBC Data Source for Excel Files

    ODBC Data Sources (32-bit and 64-bit) seem to be the same

    There are two applications under Windows Administrative Tools called ODBC Data Sources (32-bit) and ODBC Data Sources (64-bit). But their shortcuts both point to the same file: %windir%\syswow64\odbcad32.exe. I would expect the 64-bit file to have a name
    like odbcad64.exe. Why is the same file used for both 32-bit and 64-bit?

    BTW, Windows topics (selected below) should have an "Other" selection when the listed selections don't seem to fit the topic being questioned about.

    ***moved the thread to the nearest category by query.***
     
    MesPia, Aug 13, 2020
    #4
Thema:

Set up a Network Directory a an ODBC Data Source for Excel Files

Loading...

  1. Set up a Network Directory a an ODBC Data Source for Excel Files - Similar Threads - Set Network Directory

  2. Configure MS Access Driver in ODBC Data Sources to be read only

    in Windows 10 Gaming
    Configure MS Access Driver in ODBC Data Sources to be read only: Without getting too deep in the weeds, I have an MS Access database .accdb and I needed to create a System DNS connection to it in ODBC Data Sources. Did that it works can connect to it and query it, get results all gravy.However, it is kinda demanding to get the first...

  3. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Gaming
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...

  4. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Software and Apps
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...

  5. Using NTFS Mount as an ODBC Data Source

    in Windows 10 Network and Sharing
    Using NTFS Mount as an ODBC Data Source: We have a Windows 10 Pro PC running on a VM that has a mounted NFTS drive, just using the anon switch to not require credentials. The drive letter is Z and net use shows it as an NFS Network drive mount. We can browse and interact with it just fine in explorer.However, one of...

  6. -Windows 11: importing Data from source Windows explorer directory file to excel

    in Windows 10 Gaming
    -Windows 11: importing Data from source Windows explorer directory file to excel: Hi can anyone help please. I have windows 11 and am trying to import data from the source windows explorer folder named music :setup as Name/ Title/ #/ Contributing artist/ Album? Length/ Size/ Type eg MP3 I found Karl Timmermans answer to another query which helped how to...

  7. -Windows 11: importing Data from source Windows explorer directory file to excel

    in Windows 10 Software and Apps
    -Windows 11: importing Data from source Windows explorer directory file to excel: Hi can anyone help please. I have windows 11 and am trying to import data from the source windows explorer folder named music :setup as Name/ Title/ #/ Contributing artist/ Album? Length/ Size/ Type eg MP3 I found Karl Timmermans answer to another query which helped how to...

  8. How to copy definition of ODBC Data Sources easily?

    in Windows 10 Network and Sharing
    How to copy definition of ODBC Data Sources easily?: I have defined 8 "ODBC Data Sources 32-bit" on a Windows10 64 bit.I use them in a machine user interface and every time I create a new user interface I have to define these ODBC data sources from scratch. It is not complicated, but it is tedious and there is the risk of...

  9. How to installing Microsoft Excel Driver for ODBC data source 64bit

    in Windows 10 Drivers and Hardware
    How to installing Microsoft Excel Driver for ODBC data source 64bit: HI I want to add a new ODBC data source but when I go to add it the Microsoft excel driver isn't there? [ATTACH] https://answers.microsoft.com/en-us/windows/forum/all/how-to-installing-microsoft-excel-driver-for-odbc/f41aa82f-a14d-4335-88e3-446419f8b07a

  10. File DSN are slow to scan when opening ODBC Data Source Administrator

    in Windows 10 Drivers and Hardware
    File DSN are slow to scan when opening ODBC Data Source Administrator: When I trigger the opening of the 32-bit or 64-bit ODBC Data Source Administrator, and select File DSN, it takes forever to show the tab. I see this when I export a table from Microsoft Access to a SQL Server db. That I can discern, this is because the first tab the...