SQL Export

[Yardyy]

Hi,

Not sure if this is allowed or not, but here goes..

We have a database that I need to pull some data out of from the beginning of the year, i was told that i could use Excel to do this, but, excel keeps on crashing, running out of resources.

Could someone please show me the SQL script that i would use to pull the data out of a table called Stock_Rec.



Many Thanks
Yurov Ardyy

 

[croix18]

Yarddy,

To get every single field and record from a table use the following SQL:

SELECT *
FROM table_name (this case Stock_Rec)

 

[Yardyy]

Thanks for that, but the problem is that excel cannot handle all the data, and crashs.

Is there any way that i can get data from just the beginning of they year, or date range, in total there is about three years of data there, if i could get all of it that would be really good but i just dont know how to do it.

from excel i am going to export it as a csv file, so that i can import into sage.

Or even get data from a specific period say between jan2005 and jan2006.

Many Thanks
Yurov Ardyy