Import Data from Excel - Size Limits

Discussion in 'Microsoft Access External Data' started by Guest, May 25, 2007.

  1. Guest

    Guest Guest

    I am wondering if anybody knows the maximum number of records that a table
    can hold in Access. I need to import a Worksheet from Excel into Access that
    contains about 95,000 rows (records).

    Will that be a problem?

    Many thanks
     
    Guest, May 25, 2007
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    I don't think there is a max number of records. I have a table with well
    over 200,000 records. If you have trouble importing from Excel, you can
    always save the spreadsheet as a text file and bring it in that way.

    How did you get more than 65,536 rows in a spreadsheet?
    --

    Rip


    "Dina" wrote:

    > I am wondering if anybody knows the maximum number of records that a table
    > can hold in Access. I need to import a Worksheet from Excel into Access that
    > contains about 95,000 rows (records).
    >
    > Will that be a problem?
    >
    > Many thanks
     
    Guest, May 25, 2007
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thank you for your response & suggestion.

    As for more than 65,536 rows in a spreadsheet....I have no idea....it just
    kept allowing me to enter records without indicating that I passed the limit!
    That was with Excel 2007 by the way.

    "Ripper" wrote:

    > I don't think there is a max number of records. I have a table with well
    > over 200,000 records. If you have trouble importing from Excel, you can
    > always save the spreadsheet as a text file and bring it in that way.
    >
    > How did you get more than 65,536 rows in a spreadsheet?
    > --
    >
    > Rip
    >
    >
    > "Dina" wrote:
    >
    > > I am wondering if anybody knows the maximum number of records that a table
    > > can hold in Access. I need to import a Worksheet from Excel into Access that
    > > contains about 95,000 rows (records).
    > >
    > > Will that be a problem?
    > >
    > > Many thanks
     
    Guest, May 25, 2007
    #3
  4. Guest

    Guest Guest

    Probably has 2007, it allows 1,000,000 rows

    There is not record number limit in Access. I was working on one recently
    that has 1.8 million records.

    The only limit is the database size. 2Gig for 2003, I don't know for 2007
    --
    Dave Hargis, Microsoft Access MVP


    "Ripper" wrote:

    > I don't think there is a max number of records. I have a table with well
    > over 200,000 records. If you have trouble importing from Excel, you can
    > always save the spreadsheet as a text file and bring it in that way.
    >
    > How did you get more than 65,536 rows in a spreadsheet?
    > --
    >
    > Rip
    >
    >
    > "Dina" wrote:
    >
    > > I am wondering if anybody knows the maximum number of records that a table
    > > can hold in Access. I need to import a Worksheet from Excel into Access that
    > > contains about 95,000 rows (records).
    > >
    > > Will that be a problem?
    > >
    > > Many thanks
     
    Guest, May 25, 2007
    #4
  5. Guest

    Guest Guest

    Thank you Klatuu - great to know all that!

    Regards

    "Klatuu" wrote:

    > Probably has 2007, it allows 1,000,000 rows
    >
    > There is not record number limit in Access. I was working on one recently
    > that has 1.8 million records.
    >
    > The only limit is the database size. 2Gig for 2003, I don't know for 2007
    > --
    > Dave Hargis, Microsoft Access MVP
    >
    >
    > "Ripper" wrote:
    >
    > > I don't think there is a max number of records. I have a table with well
    > > over 200,000 records. If you have trouble importing from Excel, you can
    > > always save the spreadsheet as a text file and bring it in that way.
    > >
    > > How did you get more than 65,536 rows in a spreadsheet?
    > > --
    > >
    > > Rip
    > >
    > >
    > > "Dina" wrote:
    > >
    > > > I am wondering if anybody knows the maximum number of records that a table
    > > > can hold in Access. I need to import a Worksheet from Excel into Access that
    > > > contains about 95,000 rows (records).
    > > >
    > > > Will that be a problem?
    > > >
    > > > Many thanks
     
    Guest, May 25, 2007
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Access 97 number data type limits

    Guest, Feb 19, 2004, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    238
    Guest
    Feb 19, 2004
  2. js

    Import List Limits

    js, Jul 13, 2004, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    185
    John Nurick
    Jul 13, 2004
  3. Import from Excel - not all values import

    , Jul 21, 2005, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    251
    Ken Snell [MVP]
    Jul 21, 2005
  4. Guest

    I cannot get import wizard to work to import excel to access tabl

    Guest, Sep 8, 2005, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    695
    Guest
    Sep 8, 2005
  5. Linda in Iowa

    access import wizard doesn't import all rows of excel file

    Linda in Iowa, Aug 24, 2008, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    662
    Linda in Iowa
    Aug 24, 2008
Loading...

Share This Page