开发者

SSIS import excel file with merged cells

开发者 https://www.devze.com 2023-01-25 19:57 出处:网络
I have a report in Excel that has to be imported to SQL Server using SSIS.The file h开发者_JAVA百科as merged cells which don\'t seem to import properly.Instead they show up as NULL.Does anyone know ho

I have a report in Excel that has to be imported to SQL Server using SSIS. The file h开发者_JAVA百科as merged cells which don't seem to import properly. Instead they show up as NULL. Does anyone know how to import an Excel file with merged cells? Thanks.


Are you mapping the correct cell from the Excel spreadsheet? I've found it should be the first (leftmost) cell that needs to be mapped - if you use the other cell(s) it will come across as null. Can you add a Data Viewer to the Data Flow Path to check what is coming in?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号