I have xlsx file with multiple tab and each tab has more than 500 columns. I have to store these data into SQL table and table will be created for each tab with tab name.
i tried to this using C# code and directly openrowset but it always returning 256 columns.
Divrer: ACE:14 2010
Please help me to work out this problem..
The ACE OLE DB driver has an issue when the Excel file exceeds 255 columns. So I would try another angle. Maybe try converting the Excel file to a CSV file?
MCSE SQL Server 2012 - Please mark posts as answered where appropriate.
CSV is much easier then Excel! If that's an option... go for it.
It's a bit devious, but if 255 is the limit then perhaps you could read it in two steps? First Column A to IU and then IV to SP...
SELECT * FROM [Sheet1$A:IU]
Please mark the post as answered if it answers your question | My SSIS Blog:
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?