Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    column limits (2003)

    Is there a limit to the number of columns a table can have?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: column limits (2003)

    Yep: maximum 255 columns. The same holds for a query. You can find this information, and more, by typing specifications in the Help task pane.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: column limits (2003)

    Exactly what I thought - tried to import 20 columns from Excel and Access choked - I'm sure I've blown it somehow - just checking the obvious first.

    thanks again for your help

    Aunt Linda

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: column limits (2003)

    There's also a limit to the total number of characters in a record (excluding memo and OLE fields) - it's either 2,000 or 4,000 depending on a setting. so if you try to import 20 columns containing lots of text, you might run into this limit.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: column limits (2003)

    Very little text - I'm sure it's just a matter of my not being very proficient at Access - rarely use it - and not being careful enough with the matching properties rule.

    Thanks again - I'll either figure it out or give up.

    Have a great day!

    Aunt Linda

Posting Permissions

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