Results 1 to 3 of 3
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365

    Unable to identity delimiters in my saved Export

    It's been some time ago and I cannot remember the delimiters . I need to create a new SavedExport but must use the same ones.
    Is there any way in Access to find what they are ?

    The SavedExport used no formatting and was not Fixed Width.
    Reading the text file back with code shows the field delimiter is Chr$(244) and text delimiter is Chr$(218)'


    But I do not remember how I inputted this into the Wizard at design time. I assume it was a single character for the wizard to accept it.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Chr$(244) produces ô and Chr$(218) produces Ú neither of which are usual delimiter characters.
    The wizard choices for field delimiter are a comma, semicolon, or tab.
    Review https://www.access-programmers.co.uk...n-2007.197604/
    Last edited by June7; 08-15-2023 at 03:29 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    I did figure it out, needed to debug.print e.g. chr$(244) and copy/paste into the Wizard. This was pretty obvious but I was fooled thinking there was an alt key combination
    I couldn't use the delimiters you suggest as they may appear in the text, as might quotes. Looks like anything works as a delimiter which is very handy.
    Link was useful and I'll follow thru on msgs 5 abd 8.
    Thanks.

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

Similar Threads

  1. Saved Export from command button
    By thegrimmerdiscovery in forum Import/Export Data
    Replies: 2
    Last Post: 04-30-2020, 02:33 AM
  2. Export the OLE object saved as PDF in a Table
    By accesspuv in forum Access
    Replies: 2
    Last Post: 07-31-2019, 03:20 PM
  3. setting file path for saved import / export
    By krag in forum Programming
    Replies: 10
    Last Post: 01-29-2018, 08:13 PM
  4. Saved Export Specs in a shared runtime DB
    By Breedy in forum Import/Export Data
    Replies: 2
    Last Post: 11-11-2016, 03:51 AM
  5. My saved import/export are gone
    By egyhamada in forum Import/Export Data
    Replies: 4
    Last Post: 02-06-2016, 08:47 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