kcwallace Posted January 21, 2006 Posted January 21, 2006 Can someone show me how to directly add a text file into a database using SQL Server 2000. It is my understanding that I need to use a image field. I am unsure how to do this. The file is very large, and do to political constaints I cannot store a file location instead. I would also be open to storing the contents of the file in a memo field, but SQL Server returns an error saying the data will get truncated. I will also need to know how to retrieve it too. Quote Go Beavs!!!
Igor Sukhov Posted January 22, 2006 Posted January 22, 2006 Can someone show me how to directly add a text file into a database using SQL Server 2000. It is my understanding that I need to use a image field. I am unsure how to do this. The file is very large, and do to political constaints I cannot store a file location instead. I would also be open to storing the contents of the file in a memo field, but SQL Server returns an error saying the data will get truncated. I will also need to know how to retrieve it too. Load your text file into array of bytes and use that array as the parameter for the sql statement. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.