what's the SQL for inserting an OLE object into Access 2002?

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

Guest

Hi, I'm using VB.Net to insert records into a Access database. My record
contains text files which I believe can be inserted as an OLE object. I've
tried to inserted it manually, but I need to know the SQL for that, so that,
I can put it into my VB.Net code. Could anyone please give me a hand on it
please? Thank you very much!

Yaqian
 
Hi Yaqian,

As far as I'm aware, Jet SQL doesn't offer any facilities for packaging
files into OLE objects, or unpackaging them later.

In any case, storing text files as OLE objects doesn't make much sense
to me; far better to store the contents of each file in a memo field,
with (if necessary) the filename in a separate text field.
 
Back
Top