To export Access data which has more than 65000 rows with formatting and layout, you will need to set up a query to export 65000 rows at a time into separate spreadsheets.

Now from the drop-down menu, select Export plan to Excel. You can see it’s busy exporting it. For some users, it may also launch Excel automatically and take you directly to that file.

Exporting a Cell to Another Cell in Excel. Entering an equal sign followed by another cell's address in a blank cell exports the referenced cell's contents to the new location in Excel.