cool_dude Posted April 7, 2015 Report Posted April 7, 2015 Hello, I have a table with millions of records(6271585 Rows). Criteria is to import that table into a file and send to the Customer. As excel has limitation of 1048576 Rows , CSV file lo data import chesanu using SSIS. SSIS package executed successfully. When I opened the CSV (Generally opens in Excel) , its showing only 1048576 Rows. My question is , if the customer imports the file from their end , can they able to import all the rows or only they can import 1048576 rows? Answer plz..? Tnq in advance...
DaleSteyn1 Posted April 7, 2015 Report Posted April 7, 2015 oka pani chey single excel file lo multiple sheets lo vey vallaki easy ga untundhi choodataniki
cool_dude Posted April 7, 2015 Author Report Posted April 7, 2015 oka pani chey single excel file lo multiple sheets lo vey vallaki easy ga untundhi choodataniki Vallaki oke sheet lo undali anta dude. Anduke they asked to either import through CSV or Access ani.
k2s Posted April 7, 2015 Report Posted April 7, 2015 give them a small query, which they can edit as they need and run it and generate only those results needed in Excel
k2s Posted April 7, 2015 Report Posted April 7, 2015 Or if data is for a month old - segregate data for every 7 days or 5 days etc and put them in a excel/csv file
cool_dude Posted April 7, 2015 Author Report Posted April 7, 2015 Or if data is for a month old - segregate data for every 7 days or 5 days etc and put them in a excel/csv file This is kind of audit bhaiyya. And its a 1 time data load. Antha okka tab lo ney undali anta. So that's y opted for CSV file.
pythonic Posted April 7, 2015 Report Posted April 7, 2015 CSV only excel lone enduku open cheyali uncle..any text editor is fine...try to open it in Notepad++...
cool_dude Posted April 7, 2015 Author Report Posted April 7, 2015 CSV only excel lone enduku open cheyali uncle..any text editor is fine...try to open it in Notepad++... Notepad++ lo open chesina Excel limit of 1048576 Rows ey display avtunnayi dude... :(
dotnet_developer Posted April 7, 2015 Report Posted April 7, 2015 Simple..check the size of the file in both cases..
dotnet_developer Posted April 7, 2015 Report Posted April 7, 2015 Simple..check the size of the file in both cases.. Jpgif
k2s Posted April 7, 2015 Report Posted April 7, 2015 This is kind of audit bhaiyya. And its a 1 time data load. Antha okka tab lo ney undali anta. So that's y opted for CSV file. Audit kabatti... month wise data pedithey better emo adigi chudu....... small data chucks are better to handle than one large big chunk
suryausa Posted April 7, 2015 Report Posted April 7, 2015 http://stackoverflow.com/questions/16945348/excel-csv-file-with-more-than-1-048-576-rows-of-data use avutunda
pythonic Posted April 7, 2015 Report Posted April 7, 2015 Notepad++ lo open chesina Excel limit of 1048576 Rows ey display avtunnayi dude... :( Check this https://social.msdn.microsoft.com/Forums/sqlserver/en-US/283e3100-73b0-4cd8-b8f2-f31fb55eed5d/export-data-from-sql-server-to-excel-without-excel-sheet-constraint?forum=sqlintegrationservices
Recommended Posts