May 12 2017
I mostly working with Excel.
Some of excel files having large amount of data (Eg. Around 8 lakh rows and 52 Columns)
For getting some results, excel is hanging or taking more time and more functions.
But SQL is very fine to get results within seconds.
Problem is while importing excel file (Ver. 2007) it shows an error (Please find attached file)
But, It allows to import excel file of 97-2003 file format. i.e xls.
For getting result, i am saving "xlsx" file into multiple "xls" files (Coz, xls having 65536 rows only)
Single "Xlsx" file of 8 lakh records saved as 16 "Xls" files contains 50000 records per file.
And importing them into MS SQL Server.
May 14 2017