Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Pearland, Tx
    Posts
    1

    Unhappy Unanswered: Import fixed length does not recognize spaces

    I routinely import fixed length data into MSAccess2000 with no problems. Today, a "Square character" is replacing the spaces. This prevents the fields from lining up so they can be imported. I removed MSOffice and reloaded the software and have the same problem. I also attepted to have Office do a repair. This happens on multiple files that I am able to import on other PCs so it is a problm with Access on this PC. Has anyone seen this before?

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    My feeble memory seems to be dragging up something about hidden files, or hidden characters or something. I suspect you have a control on to show system objects or something like that.

    I think the square character represents character 10 in some circumstances.

    If you get really stuck, import the file into excel and then import into Access. Personally I sometimes find this better, as I can see the data as I manipulate it and Excel does have some nice data tools especially for working with tab delimited or comma delimited files.

Posting Permissions

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