Save Excel file in the text field

I need to insert Excel file (the whole file alongwith data) into a text
field in the SQL table. Is that all possible (through VB scripting or
')
Any ideas? Thanks!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!How To Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/?kbid=258038
AMB
"Test Test" wrote:

> I need to insert Excel file (the whole file alongwith data) into a text
> field in the SQL table. Is that all possible (through VB scripting or
> ')
> Any ideas? Thanks!
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
>|||You can use textcopy utility to import the excel file to an image column.
Details & examples can be found at:
http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm
Anith|||Thanks, Alejandro!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Anith,
I tried it and it works great! But my goal is to upload (or insert)
Excel files into a text field of a table. Is that all possible (I know
it is a new stuff)? If you can give me some ideas, I would really
appreciate it.
Thanks for your time!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Alejandro,
I used the article you sent me and made it work converting VB code into
VB scripting inside the DTS pacakage. The ADO stream objects is the way
to do it.
THANX for your help!
*** Sent via Developersdex http://www.examnotes.net ***