Probably a "duh" quesion, but how can I select a LOT of rows in order to export into Excel?

[dbwiz]

Searching online is just not giving me the easy answer. I know that in Excel, if you have thousands of rows and tons of columns, you can find out what the end cell is that you want to select, then put your cursor in the first cell you want to select, hit F8 then F5 (go to) and type the cell number and Voila! your whole record set is selected without scrolling for forever.

For the life of me, I have not found an easy way to do this in Access, and by golly, there has got to be a way to put my cursor in the first column of say, record 65501 and be able to select it and then go to the end of the record set and have them all selected. I have too much data to export the whole report. Any help would be GREATLY appreciated!

 

[Joe4]

You could apply filters or criteria to return just a subset of records and copy those.
Or use "SELECT TOP n" to just return a certain number of records (see: http://msdn.microsoft.com/en-us/library/bb177882(v=office.12).aspx).

 

[tad0075]

I would just query them out. But if you're just pulling every column from a specific row to the end, you could (1) highlight the row where you want to start, (2) hold down shift, and (3) press end. You can either copy/paste or go to the "External Data" tab and choose Export to Excel. No difference as far as I can tell, except that copy/paste puts the data into an existing file rather than creating a new file.