converting ole objects and packages to native format

[StanTheMan]

I've been looking all over for an answer to the question below, if anyone can help, that would be so good, it's been over a week I've been trying to figure this out..

I'm converting an access 2003 database to sql server/vb.net. I have a table with jpegs, bitmaps, pdfs, xls, etc. stored as packages. I have found a program that will extract them to a folder as images. But what i really need, is a way to preserve the table because it contains id's for the packages that correspond with records in other tables, there's thousands of packages, etc. and i would have to manually download them from the old access program as images and upload them to sql server through my vb.net app. any help turning that table into a table that contains the images, etc with the id's intact, instead of packages would be greatly appreciated, Thanks, Dan

 

[Simon_MT]

Have you tried :

http://www.lebans.com/oletodisk.htm

Simon

 

[StanTheMan]

Have you tried :

http://www.lebans.com/oletodisk.htm

Simon

Yes, that's the program i refer to in my original post, it extracts them to a folder, but i need them in a table in their native format with the rest of the row contents that identify the row as a foreign key row, thanks! Dan

 

[Simon_MT]

I would ask the question in SQL server forum. There is a process: Bulk Insert

Simon