I have Office 2007 and am trying to export a table with 500,000 rows of data into an Excel worksheet. However it is not letting me do this.
Since Excel 2007 has capacity for upwards of 1 million rows why can't I export a huge Access table.
Please let me know if this can even be done.
Thank you