Computer hardware and software
How import a table as excel file in Microsoft SQL Server Management Studio Express?
Question : How import a table as excel file in Microsoft SQL Server Management Studio Express?
I really need to just export a table as an excel because trying to do it manually by just copy/pasting is kind of painstaking and I have a lot of table to export… Any help would be greatly appreciated.
P.S.
I am not that familiar with the tool that I’m using. Already tried to explore on the applications but I can’t seem to find an option to export a table and I did search the net but seems they will use BCP to export table.
Thanks.
server management
Best answer:
Answer by doug a
Do you have installed the BIDS part of the SQL package installed?
(Business Intelligence Development Studio)
This is the part of SQL that allows you to import data.
You don’t need BIDS. From Management Studio, right click on the database that contains the table you want to export. The menu will have an option of ‘Tasks’, hover over tasks, then choose Export Data (near the bottom). This will open the export wizard. The first page is the data source, which should be set to what you have open; change this if you want a table from another database. The second window is the destination; from Data source, choose Microsoft Excel, then the path where you want the spreadsheet saved. Type in the name of the spreadsheet if you are creating one from scratch. The third page is where you can either choose a whole table/view or write a query.