Results 1 to 2 of 2

Thread: Exporting MS ACCess to MS Excel

  1. 04-09-2007, 10:26 PM #1
    jbkirby
    jbkirby is offline Registered User
    Join Date
    Apr 2007
    Posts
    1

    Smile Exporting MS ACCess to MS Excel

    How many rows can we export from MS Access to MS Excel? It seems an error always occur when i'm trying to export a huge number of lines.
    Reply With Quote Reply With Quote
  2. 04-09-2007, 11:18 PM #2
    GolferGuy
    GolferGuy is offline Registered User
    Join Date
    May 2006
    Posts
    407
    Excel will only handle 65536 rows of data. Of course if each record does not have too many fields, you could start over at row 1, column AA for example and then you could add another 65536 rows. Or you could buy Excel 2007 which holds a whole lot more rows, but I don't know how many. I just know it is a lot more than the "current" 65536 limit.

    More than likely, whatever you are trying to do can be done much better in Access by someone that knows what they are doing in Access.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules