Exporting data to xls file 1

[Syky]

Hi There!
I would like to export data to xls file.
I have table with data. Where one of the all columns is date. I would like to export all data from this table, but only data for november 2003. How Should I proceed?
Thx
Syky

Syky

 

[mimi2]

Hello,
from entreprise manager,
1.right click tables,
2.then choose 'all tasks'.
3.export data...
4.in destination dialog box, choose excel 97/2000... and give any name to your file
5. then "use a query to specify the data to transfer"
6."Build query"
7. choose your tables and the fields that are pertinent + your criterias
8.that's it !

 

[Syky]

Hi!
All these steps are clear to me! But I need to know criterias! I mean, what should be put into, to succeed with export only with data from 11/2003.

Syky

 

[esdee]

"use a query to specify the data to transfer"

write this query as:

select * from your_data_table
WHERE date >= 11/2003