Importing excel data in SQL Server 2022 getting error not able insert into SQL DB location table

[Sudhakar2301]

I am unable to add the data into SQL DB location table.
Messages
Error 0xc002f210: Drop table(s) SQL Task 1: Executing the query "drop table [dbo].[dbo.Table1]
" failed with the following error: "Cannot drop the table 'dbo.Table1', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
(SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task 1: There was an error with Source - Table1$.Outputs[Excel Source Output].Columns[column1] on Source - Table1$.Outputs[Excel Source Output]. The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard), Please do the needful

[#2]

It is referring to the table [dbo].[dbo.Table1]. Try taking out the schema name when you specified the table as it looks like it has put the schema in there twice.

Fir the View Report error try setting all the column types to VARCHAR(MAX) and try again