Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185

    Thank you for your time. I am thinking about writing the code to handle the difference in the lines. It doesn't seem to me that I will be able to change this problem from my end. I would just use an on error handle code and write in a new do.cmd that uses a different import specification. I would start this under the first cocmd data transfer in the code I have listed above?

  2. #17
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    If I am not getting any error code from the import. It just becomes unresponsive. Is it still possible to run an error handler?

  3. #18
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would just use an on error handle code and write in a new do.cmd that uses a different import specification.
    The "DoCmd.TransferText" command transfers the whole text file. There is no way that I know of to switch import specs in the middle of a transfer.


    I am thinking about writing the code to handle the difference in the lines
    I would have the code read and process every line in the text file........


    If I am not getting any error code from the import. It just becomes unresponsive. Is it still possible to run an error handler?
    Yes, you can add error handling code. But you have turned off warnings (using "DoCmd.SetWarnings False") ....??

  4. #19
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    OK so I turned on the warnings and it brought me through saying did I want to run the delete query. I said yes, then it says you are about to delete 336 rows and when I click yes it shows the import bar at the bottom and goes about a quarter to halfway through and becomes unresponsive. Most of the time this process works because access creates an error access table.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-09-2015, 12:10 PM
  2. Importing from CSV file
    By johnny1g in forum Access
    Replies: 1
    Last Post: 06-10-2014, 05:36 PM
  3. Replies: 3
    Last Post: 02-05-2014, 04:25 AM
  4. Importing file directly from a Sharepoint file (not list)
    By jstoler in forum Import/Export Data
    Replies: 1
    Last Post: 06-28-2013, 01:44 PM
  5. Importing CSV file using VBA
    By falconfox in forum Import/Export Data
    Replies: 1
    Last Post: 12-05-2012, 10:32 PM

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