Hi,
You can use SSIS or Import and Export Data to import RAW data in SQL Server.
I'm not sure what you mean from obtain a report!
If you want to create a report from imported data you can use SSRS to create your reports, but if you mean you want to see a report for the import process, when the process secussfully done it will show you a report.
Cheers
Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP