Link to home
Start Free TrialLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

SQL copy and paste data

I use to MS Access and copy and paste query results into Excel. In MS Access I would be able to copy Column heading as well as row data. However, in SQL 2005 I am not able to copy accross column headings when I use cut and paste
Avatar of tpi007
tpi007
Flag of United Kingdom of Great Britain and Northern Ireland image
Thats correct, you can however run query in query analyser and click the 'Results to File' option on toolbar. This will save data and column headings to a file. Open excel and import file and you will get column headings also.Bit slower but you will get headings.  
Avatar of Mr_Shaw
Mr_Shaw

ASKER

I can not see a buttom called Results to file. What does it look like?
ASKER CERTIFIED SOLUTION
Avatar of tpi007
tpi007
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tpi007
tpi007
Flag of United Kingdom of Great Britain and Northern Ireland image
SQL Management studio option above; the Results to file screen grab attached below

save-to-file.JPG
Avatar of tpi007
tpi007
Flag of United Kingdom of Great Britain and Northern Ireland image
Its the SQL Editor Toolbar
  • View > Toolbars > SQL Editor

Avatar of Mr_Shaw
Mr_Shaw

ASKER

Thanks, this is greate.