none
Importing Text Files Using Concordance Database Delimiters RRS feed

  • Question

  • I have a large number of text files that I need to manipulate with Access.  They are exports from The Concordance database platform. The file delimiters are þ and (ascii 20).   Access do not allow to import this characters.  How can I make Access to load them correctly?  I do not want to have to open each text files to manually change the delimiters on the text files.


    Thank you 

    Monday, April 9, 2018 4:07 AM

All replies

  • Hi there,

    Please see my reply in your other (cross) post.  You should be able to edit the system tables to add the delimiters of your choice.

    http://www.accessforums.net/showthread.php?t=71509

    Cheers,

    Vlad

    Monday, April 9, 2018 6:04 AM
  • How were you trying to import the file?  In a quick test, I had a problem importing a text file with þ as a delimiter, but I seemed to be able link to it okay.  So maybe you could link to the file and then use an append query to copy data from the linked table into a local table.

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html

    Monday, April 9, 2018 8:38 PM
  • Hi Hlopez0166,

    Is your issue solved?

    I find that you did not follow up this thread after posting the issue.

    If your issue is solved then I suggest you to post your solution and mark it as an answer.

    If your issue is still exist then try to refer the solution given by the community members.

    If then also you have any further questions then let us know about it.

    We will try to provide further suggestions to solve the issue.

    Thanks for your understanding.

    Regards

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, April 26, 2018 8:19 AM
    Moderator