User Profile

Collapse

Profile Sidebar

Collapse
havanna
havanna
Last Activity: Sep 27 '11, 10:16 PM
Joined: Jun 7 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • havanna
    replied to exporting unicode strings from Access with VBA
    in Access
    Yes, thank you. Automating my export with DoCmd.TransferT ext is no problem. Further Processing I can handle at the receiving end, ti's just some extra code I hoped to avoid.
    See more | Go to post

      Leave a comment:

    • havanna
      replied to exporting unicode strings from Access with VBA
      in Access
      That indeed produced a unicode file (I don't understand your statemend: I could not get it to work as required for the simple reason that VBA doesn't handle storing the data).
      It works perfectly with my data - and delivers unicode-formatted "?"
      But of course the last hint, text export with correct codepage is what really does it, thanks a lot :-)
      See more | Go to post

        Leave a comment:

      • havanna
        replied to exporting unicode strings from Access with VBA
        in Access
        Sorry, didn't mean to ask 3rd party support - and thanks for your being willing to help at all!
        I've done that, mdb with just one table containing minimum data including some udf strings (russian).
        I've reduced the script to just read fields and put contents into a file.

        The mdb is attached as zip, also the output.txt file made by the vba module

        maybe you know how to make the script deal with unicode:
        ...
        See more | Go to post
        Last edited by NeoPa; Jun 14 '11, 04:39 PM. Reason: Added the mandatory CODE tags - Please remember for next time

          Leave a comment:

        • havanna
          replied to exporting unicode strings from Access with VBA
          in Access
          I'm using scite for viewing, that can handle both codings and checked with a hex editor.
          Access exports tables as excel directly, there are no options to set.
          For text export I use the Cinergy Script attached.
          There are several conversions made here wich may have extra effects, but I have tried with the simplest possible (just pseudocode)
          Then Open testfile.txt For Output As #5
          with mytable
          loop through...
          See more | Go to post

            Leave a comment:

          • havanna
            replied to exporting unicode strings from Access with VBA
            in Access
            Ah, I get your point.
            in the current minimum script I just read out the contents of all fields in all rows of a table and write that to a text file.
            The result is ANSI, with multibyte characters as hexvalue 3F.
            See more | Go to post

              Leave a comment:

            • havanna
              replied to exporting unicode strings from Access with VBA
              in Access
              Yes, I can export my data to xls and get the right characters, so data is unicode.
              It's just exporting to a text file with VBA that causes trouble.
              See more | Go to post

                Leave a comment:

              • havanna
                started a topic exporting unicode strings from Access with VBA
                in Access

                exporting unicode strings from Access with VBA

                I have some russian strings in Access (2000 Version and no way to upgrade, sorry, and VBA isn't my biggest strength)
                Exporting those tables to excel works fine, but I can't manage to export in a script to a flat text file, instead I get the dreaded ??????????.

                Is there a way to do it?
                See more | Go to post
                No activity results to display
                Show More
                Working...