How to transfered the data?

Hai,
this ankan here by this side ,
IAm facing a problem itis that i want to export & import data from sql server 2000 . to & from microsoft Excel . and the data should be in the understanding fromat in which it was exprot or import to sql server 2000.
Reply me asap
With best regards
ANKAN
REPLY ME ASAP

Quote:

Originally Posted by daffurankan

Hai,
this ankan here by this side ,
IAm facing a problem itis that i want to export & import data from sql server 2000 . to & from microsoft Excel . and the data should be in the understanding fromat in which it was exprot or import to sql server 2000.
Reply me asap
With best regards
ANKAN
REPLY ME ASAP

Hey let use "Data Transformation Service Wizard for import/export datas"

How to store very large document data?

Dear all,

I am facing a problem while storing Very large document data to a single image field in SQL Server 2000. It takes very much time for documents in size upto 10 MB. And its not possible to store data more than 10 MB. If I try it gives "Connection Write (Wrapper Write())" message with state 01000 and native 4.

I have used SQLPutData and SQLParamData for this purpose.

Is there any efficient way to do this? My concern is for less time.

Thanks in advance,
AvneeshI need urgent help regarding above problem. Would somebody please send some suggestions ASAP.

Thanks in advnace,
Avneesh