Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    KY USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing from DB4 tables. (Ofc 97 SR2, Win NT 4.0)

    Access 97 has a max records import from XL of 16383. Saving the XL ss as a DB4 table bypasses that. Does Access 97 have an upper limit on the DB4 format?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing from DB4 tables. (Ofc 97 SR2, Win NT 4.0)

    I've just tested to export a table with 29376 record to a DbaseIV table and reimported it in a new mdb without a problem. I don't know if there is a limit.
    Francois

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing from DB4 tables. (Ofc 97 SR2, Win NT 4.0)

    The only limit should be the limit on how big a table can get. I suspect the Excel limit is inherent in Excel, rather than Access. Wasn't that the maximum number of rows in that version of Excel?
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Importing from DB4 tables. (Ofc 97 SR2, Win NT 4.0)

    Actually the row limit in Access 97 was 65,536, but previous versions were limited to 16,384 rows. For that reason, the export function in Access was probably limited to 16,384. It's pretty easy to get around if you simply export to a delimited text file and then pull that into Access.
    Wendell

Posting Permissions

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