Results 1 to 8 of 8
  1. #1
    godofpizza is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2016
    Posts
    4

    Question ≥ operator not transferring with transfertext

    hi all,
    I having an issue with the ≥ operator not transferring with transfertext in msaccess 2003. the result is that it ends up being transfer as '=' rather than '≥'.
    Is there any other transfertext function which would work?

    thanks

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Are you importing or exporting data?
    Are you using Fixed Width or Delimited as your option?
    If Delimited, what delimiter are you using?
    What is the full value of this field?
    What data type are you choosing for this field on your import/export?

  3. #3
    godofpizza is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2016
    Posts
    4
    Quote Originally Posted by JoeM View Post
    Are you importing or exporting data?
    Are you using Fixed Width or Delimited as your option?
    If Delimited, what delimiter are you using?
    What is the full value of this field?
    What data type are you choosing for this field on your import/export?
    exporting data
    axexportdelim
    field: "XXX 8"
    string

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    So what are you choosing as the delimiter?

    Also, how are you able to get "≥"? Are you using some special character set?
    I typically see it like this in most Office programs: ">=".
    It may be it cannot find an equivalent for that special character, or you may be limited to the type of characters you can export.

  5. #5
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    It looks like TransferText is naturally limited in the characters it can export, without doing something special.
    See: https://support.microsoft.com/en-us/kb/308686

  6. #6
    godofpizza is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2016
    Posts
    4
    Quote Originally Posted by JoeM View Post
    It looks like TransferText is naturally limited in the characters it can export, without doing something special.
    See: https://support.microsoft.com/en-us/kb/308686
    thanks JoeM, are there other types of functions in access which can export that character?

  7. #7
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I honestly cannot say. I have never had to deal with that issue.
    Did you try options 4 or 5 from that linked article I gave you?

    BTW, where did that data come from? How did you get that value in Access in the first place?

  8. #8
    godofpizza is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Jan 2016
    Posts
    4
    it's results for biology testing. I think I might have pasted it a field.

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

Similar Threads

  1. Finding .transfertext [specificationname]
    By pplstuff in forum Access
    Replies: 4
    Last Post: 03-19-2019, 07:03 AM
  2. running a loop with transfertext
    By mike02 in forum Access
    Replies: 16
    Last Post: 08-20-2012, 01:54 PM
  3. use vbs and TransferText cmd to import csv
    By conway in forum Import/Export Data
    Replies: 1
    Last Post: 02-03-2012, 08:38 PM
  4. TransferText
    By za20001 in forum Import/Export Data
    Replies: 1
    Last Post: 01-03-2012, 11:57 AM
  5. TransferText problem
    By rossib in forum Import/Export Data
    Replies: 1
    Last Post: 12-17-2009, 04:57 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