Hi Guys!

Need your help. I don't know if this is the correct section for my topic. Sorry if this isn't.

Anyways, here is my problem.

I have an ms sql table:

ID Date Name Location
12345 2012-05-03 00:00:00.000 AAA AAA
12346 2012-05-18 00:00:00.000 BBB BBB
12347 2012-06-20 00:00:00.000 CCC CCC
12348 2012-06-13 00:00:00.000 DDD DDD

I need it to appear in excel files but it should be separated depending on the Date Column. And filename of the excel files has months and year on it also depending on the date like this: ExcelFile_MMYYYY.xls

Based on table above, I will have 2 excel files:

1. ExcelFile_052012.xls (then it contains below data)

ID Date Name Location
12345 2012-05-03 00:00:00.000 AAA AAA
12346 2012-05-18 00:00:00.000 BBB BBB


2. ExcelFile_062012.xls (then it contains below data)

ID Date Name Location
12347 2012-06-20 00:00:00.000 CCC CCC
12348 2012-06-13 00:00:00.000 DDD DDD

Please note that the sample table above will have additional data every day. That means if it is now july there will be three excel files result. (ExcelFile_072012.xls which contains July date.)

Please help me guys. I really need this. Thanks!