Transformation from MSAccess to SQL server using Biztalk

Hi All,

Can you please tell me the steps to transform data from MSAccess table to SQL Server table using Biztalk.

T

January 29th, 2015 10:07am

Hi,

you would need to write a custom component most probably in C# using ADO.net and call that in an orchestration to read from access and for SQL you can use the OOB adapter.

Free Windows Admin Tool Kit Click here and download it now
January 29th, 2015 10:12am
While we all love BizTalk, the first path I would investigate to move data from Access to SQL Server would be SSIS which has native Access file support.
January 29th, 2015 4:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics