SQL Create Table syntax for OLE Object fields

G

Guest

Does anyone know the correct syntax for the SQL "Create Table" statement when
you want to create a field with the OLE Object data type? I tried
dbs.Execute "CREATE TABLE TagGraphic (TagGraphic OLE Object);" to no avail.
 
J

John Nurick

I don't know for sure, but the help article "Equivalent ANSI SQL Data
Types" suggests that it's IMAGE or OLEOBJECT.
 

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

Append data to linked SQL Server 2008 table 0
Linked OLE Object 3
OLE embedding query 1
Using Macro to export from Access to excel. Error message 3
OLE Object Data Type Question 8
Access OLE Object error in Access 2010 2
How to Link a file instead of embeding in Access Table 3
Access 2007 Database - OLE / ACE 2

Top