Question Sql Server Data Copy Cheyali Excel

[littlemoon]

Hello,,,

Sql query nunchi data pull chesaka excel loki ela export cheyachu using SSMS?

[ilovekajal]

aa dat ameedh aright click chesthey export aney option untadhi anukunta.............

[littlemoon]

[quote name='TITANIC' timestamp='1343831633' post='1302237465']
aa dat ameedh aright click chesthey export aney option untadhi anukunta.............


[/quote]

ledhu ala anduke doubt..

[Robinhood1676]

yes you can copy the output and paste it in excel or else use import and export wizard to transfer data to excel.

[Robinhood1676]

yes you can copy the output and paste it in excel or else use import and export wizard to transfer data to excel.

[Anta Assamey]

[indent=2] [/indent]

[ChampakDas]

Select the records Right click 'Save Results As'

[Robinhood1676]

Result lo first column serial number kahda daani meedha right cliekc chesthe column with headers ani option meedha click cheyyi and open excel and paste it
thats it

[littlemoon]

[quote name='ChampakDas' timestamp='1343833616' post='1302237626']
Select the records Right click 'Save Results As'
[/quote]

thank you

[littlemoon]

[quote name='Robinhood1676' timestamp='1343833825' post='1302237648']
Result lo first column serial number kahda daani meedha right cliekc chesthe column with headers ani option meedha click cheyyi and open excel and paste it
thats it
[/quote]

the only option i see is copy, select all ,print and page setup


copy cheyachu ani telsu but data pedhaga unte ela ani.

[Bairagi From Bapatla]

table lo ki data ni load chesi import and export wizard vadu.... or vachina results ni copy paste... but excel will take only 65000 records... u cant export more than that.

[Robinhood1676]

[quote name='littlemoon' timestamp='1343833963' post='1302237670']
the only option i see is copy, select all ,print and page setup


copy cheyachu ani telsu but data pedhaga unte ela ani.
[/quote]

no problem data peddaga unna anni records select ithayi kadha......copy kuda ithayi....

[ChampakDas]

dude...Page setup pina Save Results as ani undhi kada...
[quote name='littlemoon' timestamp='1343833963' post='1302237670']
the only option i see is copy, select all ,print and page setup


copy cheyachu ani telsu but data pedhaga unte ela ani.
[/quote]

[littlemoon]

[quote name='ChampakDas' timestamp='1343834115' post='1302237692']
dude...Page setup pina Save Results as ani undhi kada...
[/quote]

kani ala excel lo open chesthe format change aindi

[littlemoon]

[quote name='Bairagi From Bapatla' timestamp='1343834031' post='1302237678']
table lo ki data ni load chesi import and export wizard vadu.... or vachina results ni copy paste... but excel will take only 65000 records... u cant export more than that.
[/quote]

idhi table kadhu just a long query to retrieve data..