Problem importing data from an Excel Spreadsheet.

Question

My spread sheet is a Christmas list that I've used to generate labels from Access for years. This year when I use External Data/New Datasource/From File/Excel on the newest version of the spread sheet, I get the error below.

I've done a SAVE AS in Excel to get rid of the "from the internet" problem. I've loaded older versions of this spread sheet successfully. I've deleted empty rows. What else can I look for?

Answer 1

The file doesn't appear to be "missing." It shows up as a file that can be imported when I browse from Access and I click on it.

The older versions of the file that still can be loaded all have spaces in their names and are all in the same location as the problem file.

Answer 2

Okay, thanks for eliminating those possibilities. You are sure that the file which appears to be missing has the same name as the one used in the VBA line, so we move on to look at other possibilities.

Try saving the file with no spaces embedded in the file name. Also confirm that the file can be opened in Excel. The error message suggests two possible problems, including something being wrong in the name and something being wrong in the file format. Please rule both of those out as well.

Other things you seem to have considered include whether the file is in a Trusted Location, but again, to rule that out, can you double check that?

Answer 3

As for .xls vs .xlsx, I've been using versions of this spread sheet for around 15 years.

Answer 4

I've used lots of file names. I've loaded old .xls files successfully. The funny file name is to distinguish my SAVE AS new file.

Answer 5

The spelling of the file name?

Is it really called "Christmas List 2023x.xls"?

That x after 2023 and before the . looks a bit curious to me. And these days it would seem more likely that it is an xlsx file, rather than an xls file.