Export from SQL Server to Access

Dear friends

How to export data from SQL Server 2000 to Microsoft Access using SQLDMO

Hi Peter,

I move it from BCL forum to SQL Server SMO/DMO forum where I think it's more appropriate.

Thank you for your active participation!

|||I don′t think htat DMO/SMO is the right thing for you as DMO/SMO is mainly used for administering SQL Server. You could wite an application using any data library like ADO /JET / SNAC to accomplish this. But doing this might need a lot of coding. consider using any migration tools for this or data pumps like SSIS.

Jens K. Suessmeyer.

http://www.sqlserver2005.de