Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    23

    Unanswered: Spaces in column title

    Good day,

    I have several columns that have spaces before and after the titles. Example, " NAME_FIRST" or "NAME_LAST ". Number of spaces can be different every week, its imported from outside source. I can't change column titles. However, I need to SELECT * from these columns ignoring spaces.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    This seems very unusual. When you import data having leading or trailing spaces in the column names, Access removes them. And if you try to create a table with such column names Access pops an error message (see attachment).

    Theorically you could issue SQL DML statements to change the column names or dynamically create queries based on the columns ordinal position (if this does not change).
    Attached Thumbnails Attached Thumbnails ScreenShot001.jpg  
    Have a nice day!

  3. #3
    Join Date
    Jan 2012
    Posts
    23
    Inserting table name fixed the problem.

Posting Permissions

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