Using a field in to store the contents of a text file.

[Guest_imported]

In my sql database Table I want 3 fields ID
Name
File

I want the file field to store the contents of a text file (not the path). The size of the content may be any size, maybe 1mb or 100mb.

Can anybody help me by showing me how to store the contents of a text file into an SQL DB Table? Is it even possible. Would binary help??

Thanks in advance.

 

[tlbroadbent]

Review the following topics in SQL BOL.

Using text and image Data
Managing ntext, text, and image Data
Modifying ntext, text, or image Values
Retrieving ntext, text, or image Values
Text and Image Functions
Using text, ntext, and image Functions Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Guest_imported]

Thanks for your suggestions, I will look them up. I also did check out the faq183-874... I think I know what you were trying to point put...but sometimes it's hard to search for something when you don't know how to begin.

 

[tlbroadbent]

I agree that it is hard to search the forums. The same question may have been asked in several ways. Or the same words may be used to ask different questions. The ways we think about problems differ, sometimes our language is different and certainly our experiences vary.

Good luck with your project. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin