Slick, this is what my friend said:
Do an auto increment with all records, then do a view, sort view by increment, in there, write select top 65.535 (that’s how many records it can take in one go) Then delete those records from Access (make a back-up first), then take the next 65.535. They will go in the next Excel sheet, then just continue to export and delete from view until you have them all.
Hope this helps!![]()
Bookmarks