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

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
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access OLE Object error in Access 2010 2
Inserting an OLE Image 1
OLE OBJECT HELP 1
OLE Object field... 1
Assigning an emf file to an OLE object with Access VBA 1
Access 2000 - Insert OLE object programatically into a forms OLE object field 0
unbound OLE PDF Object in Access Report doesn't update 1
Inserting a excel spreadsheet into an Access OLE Object fields 0

Top