cool_dude Posted January 30, 2015 Report Posted January 30, 2015 Hii guys, I have a sql table with 11 million records. Due to excel limitations I'm importing the table into csv file. Problem enti ante when I open the csv file adhi blank ga chupistundi but the file size is about 2GB Any reason for this issue? Vere em options unnayi to import huge table as one single file? Thanks in advance
loveindia Posted January 30, 2015 Report Posted January 30, 2015 ideally, you cannot open a 2gb csv file man, it will take a lot of time andukey empty ga kanapadutundi.... instead you can move the data per 65536 rows to a new sheet of excel, so that you can see different sheets in the file.... so it will be okay to see.... good luck man... sql smell vastey assalu aagadu man naaku....
JUJUBI_JULABI Posted January 30, 2015 Report Posted January 30, 2015 xml .. research cheyyi xml mida .. work out aythadi
loveindia Posted January 30, 2015 Report Posted January 30, 2015 xml .. research cheyyi xml mida .. work out aythadi SQL antey chaalu ekkadekkadi nunchoo vaalipotaaru man... india nunchi raava inka nuvvu man...
JUJUBI_JULABI Posted January 30, 2015 Report Posted January 30, 2015 SQL antey chaalu ekkadekkadi nunchoo vaalipotaaru man... india nunchi raava inka nuvvu man... vachesna kada 6 months back eee
kattularattayya2 Posted January 30, 2015 Report Posted January 30, 2015 Hii guys, I have a sql table with 11 million records. Due to excel limitations I'm importing the table into csv file. Problem enti ante when I open the csv file adhi blank ga chupistundi but the file size is about 2GB Any reason for this issue? Vere em options unnayi to import huge table as one single file? Thanks in advance I think writing process complete avvaledemo file ki complete gaa.. or it takes time to open the file completely..
cool_dude Posted January 30, 2015 Author Report Posted January 30, 2015 ideally, you cannot open a 2gb csv file man, it will take a lot of time andukey empty ga kanapadutundi.... instead you can move the data per 65536 rows to a new sheet of excel, so that you can see different sheets in the file.... so it will be okay to see.... good luck man... sql smell vastey assalu aagadu man naaku.... Tnq bhaiyya. Nenu anukunna nee nundi sure ga reply vastundi ani. But any link or logic to implement data to split in multiple excel sheets?
loveindia Posted January 30, 2015 Report Posted January 30, 2015 vachesna kada 6 months back eee aa 6 months back ey message chestaa annav... adi inka raakapoyesariki inka raaledemo ani asking man... mustang thatha kuda sql ye anta man... I am trying to change technology man...
cool_dude Posted January 30, 2015 Author Report Posted January 30, 2015 xml .. research cheyyi xml mida .. work out aythadi Ohh xmL kuda vastunda. Let me chk it..:) tnq
loveindia Posted January 30, 2015 Report Posted January 30, 2015 Tnq bhaiyya. Nenu anukunna nee nundi sure ga reply vastundi ani. But any link or logic to implement data to split in multiple excel sheets? logic antey ssis lo implement cheyyali man... can you use ssis??? if so evening naa class aipoyaka oka link istaanu... try it man.. vachindi cheppadaaniki noppi enti man... sada mee premaku baanisaa ee loveindia babu man....
loveindia Posted January 30, 2015 Report Posted January 30, 2015 Ohh xmL kuda vastunda. Let me chk it.. :) tnq yes xml straight forward and easy man...
cool_dude Posted January 30, 2015 Author Report Posted January 30, 2015 logic antey ssis lo implement cheyyali man... can you use ssis??? if so evening naa class aipoyaka oka link istaanu... try it man.. vachindi cheppadaaniki noppi enti man... sada mee premaku baanisaa ee loveindia babu man.... Yes ssis vachhu.. Sure man tnkz for u r help...
pachimirchi Posted January 30, 2015 Report Posted January 30, 2015 relational data ni file system ki y bringing?
vasu123 Posted January 30, 2015 Report Posted January 30, 2015 logic antey ssis lo implement cheyyali man... can you use ssis??? if so evening naa class aipoyaka oka link istaanu... try it man.. vachindi cheppadaaniki noppi enti man... sada mee premaku baanisaa ee loveindia babu man.... sada mee premaku banisa, lol , sampu caption idi. SQLesh Babu ani piluchukovacha loveindia bhayya.mimmalni
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts