SQL Server - Need to import data that was exported from sql to excel back into sql

I have exported data from sql into excel and thought it would be a simple case of using an import task to import it back into sql.

It does not seem to work

Please can you advise on what is the best way forward. The data is a sql dataset for sage 200.