Share via

Problem importing data from an Excel Spreadsheet.

Anonymous
2023-12-09T20:53:41+00:00

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?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Anonymous
    2023-12-10T03:52:38+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-12-09T21:30:22+00:00

    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?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2023-12-09T21:17:14+00:00

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

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2023-12-09T21:15:13+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  5. George Hepworth 22,855 Reputation points Volunteer Moderator
    2023-12-09T20:57:44+00:00

    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.

    Was this answer helpful?

    0 comments No comments