DragerDerek
Programmer
I am trying to migrate an Access database to a SQL Server Database programmatically without the use of DTS in VB.Net.
The problem comes in Access OLE Data Type to Image Data Type of SQL Server. I have tried using the getbytes command of datareader. No errors during the migration but I am unable to view the image.
I found out that the way the access saved the image was setting focus on the image control and doing a paste command.
The question:
1. Can I automatically convert the OLE object into an Image data Type of SQL Server?
2. If not, is there a way to retrieve the OLE object and create a temporary using VB.Net?
Hope someone can help
The problem comes in Access OLE Data Type to Image Data Type of SQL Server. I have tried using the getbytes command of datareader. No errors during the migration but I am unable to view the image.
I found out that the way the access saved the image was setting focus on the image control and doing a paste command.
The question:
1. Can I automatically convert the OLE object into an Image data Type of SQL Server?
2. If not, is there a way to retrieve the OLE object and create a temporary using VB.Net?
Hope someone can help