Results 1 to 4 of 4
  1. #1
    mp3909 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    136

    DoCmd.TransferText

    My DoCmd.TransferText has no specification specified but when the code tries to execute that block of code, I get an error saying specification "XYZ" not found.



    It's strange.

    Would anyone know this is happening.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    Did you look and see if the spec is there?
    did you put the spec name in the command line?

  3. #3
    mp3909 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    136
    Spec is there.
    No, I did not specify the spec name in command line

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Are you doing this via Macro or VBA?
    If VBA, can you post your exact code for us to see?

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

Similar Threads

  1. docmd.TransferText WITHOUT Import spec?
    By markcrobinson in forum Access
    Replies: 1
    Last Post: 08-07-2017, 03:37 PM
  2. DoCmd.TransferText Function issue
    By nick243 in forum Import/Export Data
    Replies: 7
    Last Post: 07-19-2016, 12:00 PM
  3. Docmd.TransferText Spec File Not Found
    By Patrick.Grant01 in forum Programming
    Replies: 7
    Last Post: 05-22-2012, 09:32 AM
  4. DoCmd.TransferText acExportDelim Troubles
    By svcghost in forum Import/Export Data
    Replies: 1
    Last Post: 12-14-2010, 02:35 PM
  5. DoCmd.TransferText only if file is new
    By Coolpapabell in forum Programming
    Replies: 1
    Last Post: 10-14-2009, 01:57 AM

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