MS Access 2007 Blob Image export?

Question

I have a MS Acccess 2007 database where we have inserted jpg images as blobs. I am looking for a tool that can export these images to MS SQL Server database.

Any advice will be appreciated.

Rob

Answer 1

If you are a programmer, write a quick code in C# using. You need to use OleDbConnection, OleDbCommand, OleDbDataReader

OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\db1.mdb");
//create the command object and store the sql query
OleDbCommand aCommand = new OleDbCommand("select * from image_table", aConnection);
OleDbDataReader aReader = aCommand.ExecuteReader();
//now read the data and dump it
while(aReader.Read())
{
    // your code here
}

Ref: http://www.csharphelp.com/2006/01/ms-access-application-with-c/

OR

1. export your data to SQL Server.
2. Using the SQL Management Studio export table to SQL query