I have both MS Office 2007 and MS Office 2010 installed on my PC. I am working in Access and my D/B is quite large. If I want to have the table in Access output to Excel, I need it to go to Excel 2010 due the size of the D/B. Excel 2007 limits me to 65K rows as Excel 2010 can handle over a million rows.
Any help would be greatly appreciated.