Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 SQL for OLE

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-17 : 16:54:48
Brendan writes "Some of us, working in the darker ages, don't have any access to SQL server and are forced to find other alternatives...

Using MS Access, how do you structure an SQL statement that allows you to insert different types of items into that OLE container field?

And, in the case of ADO, would you do there?
Assuming that the file is local on the same system...

INSERT INTO oleItems... (msWordFile)...("C:\thisfile.doc")
or
objRs.fields(msWordFile) = "C:\thisfile.doc"

arrrrggghh!

sincerely,

confused."
   

- Advertisement -