Forum Discussion
Solved
Importing excel data in SQL Server
Hi All, I am using SQL Server 2022 Express Edition(Not a licensed one). I couldn't able to import excel data in SQL Server for Power BI Dashboard. Can someone help me out to resolve this. PFA error ...
"Text was truncated or one or more characters had no match in the target code page.".
As I already wrote, source text to long or you try to import Unicode (nvarchar) into a varchar column.
Check source + target data types & max length.
Try increasing the size of the data definition in the previous wizard to max. Generally, it is easier to just set all the column types to VARCHAR(MAX). Then sort the data types out once you have it in a staging table.