asked on

HOW TO EXPORT the DATA FROM SQLSERVER TO EXCEL FLAT FILE

To whom concerned by a very difficult Christelle to attract

I have the task to do an extract EXCEL from SQLSERVER before 8 PM
today by my new chief of project in my second job who is
an english university Edimburg student.

I use SSIS from microsoft but it is very difficult is there a way to do that please???

Best Regards David in Love

edtechdba

If this is a one-time data dump and you are using SQL Server Management Studio, then you should be able to ..

1. Right-click on your database in SQL Server Management Studio (where your database object resides; whether a stored procedure, table or view)
2. Click on Tasks > Export Data
3. Follow the directions of the wizard to export your data into an excel spreadsheet

You will also have the option of saving your SSIS export process, which can give you a template for exporting this data faster in the future.

ASKER CERTIFIED SOLUTION

SThaya

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Member_2_861731

Another, and very archaic, option is to create your query in a query window, execute it, select all, copy with headers and paste into Excel.

Just be aware that if you do this, any numbers with trailing (or preceding) zeros will be converted to number, causing your trailing (or preceding) zeros to disappear.

Hope it helps.

DavidInLove

ASKER

Thanks