How do I load a file into the database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm at a loss, what I'm trying to do is to copy a MS-word document from the
file system into access.

I have a button that lists types of events and what I want is if they select
event: "Trade Show" then a file such as c:\tradeshow.doc can be copied into
the database in a field called content.

This content field is a varbinary(max) field in a SQL Server db that is used
to store word and excel documents. I can drag and drop files into the field
but can't seem to figure out how to copy. I tried LOADFROMFILE but it seems
to be for attachment datatype....

any assistance would be greatly appreciated.

thx
 
I suggest you create a hyperlink to the file. Storing documents in your
Access datbase will cause it to blow the size limit fairly quickly
 
HI Dave,

Thanks - however, it didn't answer the question. I am not concerned about
bloating. MY customer wants to store documents in SQL Server and use an
access form to get them there. Therefore, my question is how can I go
about automatically loading a word template into Accesss from a form. I have
a form with a combo box that lists several types of events. Behind that I
would like to have access go get a word template and store it in the content
field in my database. From there I have full-text indexing configured on the
sql server side.

So I've tried loadfromfile and that appears to be for attachment data types
only. I can drag and drop files but would like to be able to select an event
type and have a process go off and load the file into the database.

Does this make sense? thanks for your assistance with loading a file into
the database.
 
Back
Top