<p>does anybody know how to save and retrieve files in MS SQL-Server 2000?  I guess the image data type could be used as a container.</p>
<p>I want to import/export the following file types: DOC, XLS, PDF, BMP, TIFF, etc.</p>
<p>Due to resource issues we are using MS-Access 2007 as the front end, so I am looking for VBA code.</p>
<p>Thanks in Advance.</p>

You can do this using GetChunk and AppendChunk.
From
this post
you might find
this link
helpful!
One thing to watch out for:
When using certain providers, most
  notably ODBC to SQL Server and other
  databases, you may have to take
  special care in retrieving BLOB data,
  such as placing BLOB columns at the
  end of the field list and referencing
  all non-BLOB fields prior to access
  BLOB columns.
Best of luck!