How to bcp table to a new temp table in asp coding?

[vijayauvn]

Hi All,

Please can anybody help in this context?

I have a table in SQL server DB (xyz table)

I want to now code in asp that :

bcp xyz to a new temporary table similar to xyz table.

Immediate reponse is appreciated.

Thanks in advance,
Vijaya

[debasisdas]

you want to copy only the data or entire table (both data and structure ) ?