re: Import from files

2002-10-23 Thread Egor Egorov
Alan, Wednesday, October 23, 2002, 2:06:05 PM, you wrote: AM> Is it possible to update a field using SQL with the contents of a text file AM> previoously written to disk? AM> I want to update a mediumtext field with the contents of c:\data\mytext.txt AM> file. AM> update mytable set mymediumtext

Import from files

2002-10-23 Thread Alan McDonald
Is it possible to update a field using SQL with the contents of a text file previoously written to disk? I want to update a mediumtext field with the contents of c:\data\mytext.txt file. update mytable set mymediumtext= filecontents where id=number... ? Alan --