Page 1 of 1

Export from MSSQL 2008 to *.xls

Posted: Fri Jun 01, 2012 5:01 pm
by Vaalar
Hi,
I`m not sure it`s possible to solve my problem with XLS.
I need to make an export from table in database ( MSSQL 2008 Express ) to *.xls file.
It should looks like this:

Customer | Number | tons | hour | tons | hour | tons | hour
You | 3 | 33 | 12:00 | 31 | 14:00 | 42 | 15:30
We | 1 | 22 | 10:00 | |
He | 2 | 9 | 17:00 | 15 | 19:00 |

The number column defines how many times the customer has delivered the products to the stock.
There is also Hour - the time when the customer arrived and Tons - the weight of the material

In my table data looks like this:
Customer | Time | Tons
You | 12:00 | 33
He | 17:00 | 9
We | 10:00 | 22
You | 14:00 | 31
He | 19:00 | 15
You | 15:30 | 42

Plz can you help me with this.

Re: Export from MSSQL 2008 to *.xls

Posted: Sun Jun 03, 2012 5:24 pm
by larsa
Hello

I don't think I can help you with a general solution for this. You have to write an app that browses trough the table and fills the excel file according to what you want.