ETL and Data Integration tools - Modern ETL software for everyone

I am trying to import the attached file into SQL server.

It uses an excel addin to populate values on the sheet (this is a static copy of the data).

Although I can read the data when validating from the excel screen, I cannot see the data in the excel sheet when I try to map the data to the sql server table.


Thanks

You are probably using ODBC to get data from Excel
It creates more problems than solves
Do not use it.
It does not work

use direct Excel conenction instead it does work.

Have a look at screenshots attached

Mike