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
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Importing OLE Object from Access to Sql server

Author  Topic 

mjnsub
Starting Member

2 Posts

Posted - 2012-05-17 : 16:46:46
Hi Dears
I have a table in Access 2007 that has a finger print column

the type of this column is OLE Object

I want the way of transferring this table from Access table to sql server that insure the state of the contents of the OLE Object column data.


Best wishes


Best Wishes

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-05-18 : 04:14:35
Isn't this just binary data? Create a varbinary(max)-column in your sql server table and try to insert the images there.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

mjnsub
Starting Member

2 Posts

Posted - 2012-05-18 : 09:23:44
Hi Lumbago
Sorry, doesn't work

I am still waiting for help

Best Wishes
Go to Top of Page
   

- Advertisement -