In the attached file there is an Excel sheet. When I try to import this into Excel with the Access Import Wizard - well things happen. Most of them are good and some are not.
It refuses to import what i would call on the Excel spreadsheet "subheadings". These are heading that are not at the top of the spreadsheet but below that main heading. I have included two snippet shots of the subheadings. Why is Excel not importing these along with everything else?
The are still text files albeit with a different background color. They just are left out for some reason.
Every cell has an apostrophe in the first space of each Excel cell. This make them text files. I must do that in preparation to import into MS Access. If I do not I get a bunch of errors.
My question is why are they left out?
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed