Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can SQL server store OLE objects (eg word documents) 2

Status
Not open for further replies.

gordonl

Programmer
Mar 15, 2001
17
0
0
GB
I have an Access database that I want to upgrade to SQL server version 7. However, the Access tables store word documents - but I can not see the OLE datatype in SQL server.

Am I right in assuming there is no way for SQL server to store such data types.

What about SQL server 2000.
 
There is no OLE type, but you can store any data in the binary datatype including images, documents etc.

Chris Dukes
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top