Results 1 to 2 of 2

Thread: Import Issues

  1. #1
    Join Date
    Jul 2002
    Posts
    4

    Question Unanswered: Import Issues

    I am trying to import a fixed width text file. The problem I am having is that negative numbers in the text file are formatted as 999- with the negative sign trailing the number. Access 2000 does not recognize this format and I get import errors as a result. I don't know how to get Access to recognize this. Any suggestions? Thanks.

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    Try manually manipulating to capture 999- in a field. Make the field a text field or any field type access will accept.

    Once imported use left and right to manipulate the trailing value from one side to the other, then convert to a number field.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •