Results 1 to 2 of 2
  1. #1
    NicoNWA is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    1

    X64 ODBC query not working on mapped drives

    Using Office 2016 64bit with 64bit ODBC DSN and using a access 2016 database to pull MS queries from text file to excel.



    If the query file is stored anywhere on local PC >>>>> it works.
    If the query is stored on network location and its accessed via UNC path >>>>> it works.
    If the query is stored on network location and its accessed via "Mapped network drive" >>>>> not working.

    Comes up with the following error:

    Click image for larger version. 

Name:	X64 ODBC query error.jpg 
Views:	8 
Size:	50.2 KB 
ID:	29182


    Any Suggestion/help?

    Thank You in advance.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Why are you exporting to a text file then importing that text file into excel? Why not just export directly to excel?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-28-2015, 04:12 PM
  2. Replies: 1
    Last Post: 04-21-2015, 10:20 AM
  3. Record Source is being Corrupted that drives Form
    By CementCarver in forum Forms
    Replies: 16
    Last Post: 08-01-2013, 01:10 PM
  4. Replies: 6
    Last Post: 07-19-2013, 01:50 PM
  5. Access and NAS drives
    By ekkg in forum Access
    Replies: 1
    Last Post: 07-06-2012, 08:30 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums