I have some code that loops through some selected Excel spreadsheets, links to them, and appends the data from sheet1 to my table. The problem is that sometimes the Excel files have a chart object that gets it's own sheet. When this happens, I get an error in Access saying "External table is not in the expected format."
How can I get around this?
Here's the code where I have the problem:
Code:DoCmd.TransferSpreadsheet acLink, , "Temporary", path, True