I have an Excel file that does not exist. I am hoping to create the excel file and worksheet; however, the "New..." button does not work when I click on it. All it does it make the "Excel Destination Editor" screen disappear.
The Data Access mode is set to "Table or View".
Am I doing something wrong or is this a bug?
I did seem to have success when I switched to 97-2003 format.