My database consists of importing excel spreadsheets from another source. I have no control over the source but they export spreadsheets that don't seem to work right away. I have to open them up. Then i get
"The file you are trying to open, [Filepath].xls, is in a different format than expected by the file extension. Verify that the file is not corrupted and is from a trusted source before opining the file. Do you want to open the file now?" "Yes, No, Help"
Then I have to Save As on the file and save as Excel Workbook, which will make it an xlsx. I cannot simply change the file extention because it will then say the extension is not valid once you try to open it.
Can I have access have excel open/say yes, then save as?
If so how do I do that?
"The file you are trying to open, [Filepath].xls, is in a different format than expected by the file extension. Verify that the file is not corrupted and is from a trusted source before opining the file. Do you want to open the file now?" "Yes, No, Help"
Then I have to Save As on the file and save as Excel Workbook, which will make it an xlsx. I cannot simply change the file extention because it will then say the extension is not valid once you try to open it.
Can I have access have excel open/say yes, then save as?
If so how do I do that?