Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    New Orleans, Louisiana, USA
    Thanked 0 Times in 0 Posts

    fields in Access (Access2000)

    I have to send a comma delimited file to another company. The information they want requires 312 fields in a row. Excel only holds 256 fields. They asked why I can't just merge the info in Access and have it all in one row. How many fields can you have in a row in Access? And if it is possible, can you do a comma-delimited file directly from Access?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: fields in Access (Access2000)

    That number of fields in a row seems excessive. I'm glad it's their headache and not mine! It isn't just the number of fields in a table but the overall length of a record that can bite you in Access. In any case, 255 is the maximum fields in a single record and the maximum number of fields in a query. That doesn't mean you can't work around the limitations, but it takes code to create and populate a text file directly instead of by exporting data in that format.

Posting Permissions

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