I’m working in SQL Server Management Studio and I moved a large dataset from Excel into SQL Server using ETL commands, however it puts all the data into a table called dbo.Data$ and I want to move some of the columns from this (dbo.Data$) into several other tables I have created in with the same column names. It’s also telling me about data type conversion issues present between some of the attributes.

I tried running some basic SQL INSERT commands to move the data, but it did not work, the tables are still unpopulated. Is there a better command to make this work?