Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limit on rows export to Access (Access/Escel 97 SR-2)

    When we try to export in Access from Excel it will only take 16,384 rows. Is there a limit in Excel as to how many rows can be exported? Any suggestions on how to import a larger quantity of rows? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    Yes, there is a limit and I know of no way around it except of course to break things down to smaller export chunks. See this article: <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;en-us;Q291951>http://support.microsoft.com/default.aspx?...b;en-us;Q291951</A>

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    Thanks so much. A fellow associate has been having major problems with this for quite some time. Even though I am self taught on Access I didn't have a definitive answer. This will help us work around it. Thanks again. <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    Are you exporting data from Access *TO* Excel?
    Or are you IMPORTING data from XL INTO Access?

    If the first, you would get better results pulling the data into XL by using data, get external data, create new database query.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Jan 2002
    Location
    Black Earth, Wisconsin, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    We are in Access trying to export information from Excel.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    Hi Butterfly,

    Now you still have me confused, I'm sorry.

    you wrote:

    <<We are in Access trying to export information from Excel>>

    But as i would state it, one either is:

    1) IN Access trying to IMport information FROM Excel
    2) IN Access trying to EXport information TO Excel

    Which is it?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limit on rows export to Access (Access/Escel 97 SR-2)

    Jan: Just curious, why could he not be in Access trying to export data from Excel?
    Legare Coleman

Posting Permissions

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