Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003

    Unanswered: Number of rows that can be Exported.

    I have written a VB code to export MS Access to text file.
    My table in MSAcess has 130576 records. And MSAccess exports only till 81565 records. I did a direct export to text file from Access which then also copied only same number of rows.
    Can anyone tell me how to overcome this.
    any parameters needs to be set?

    Thanks in Advance.

  2. #2
    Join Date
    Jan 2003
    Aberdeen, Scotland, UK
    I tried it and I got a message about the max records you can copy to the clipboard.

    Put it to excel instead?

    P.s. why write code? just export it using the toolbar.

  3. #3
    Join Date
    Jan 2003
    Excel will only hold 65536 rows of information on one worksheet. I've not seen a limitation with Access though.

Posting Permissions

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