how to Copy a table from mssql to ms access

Is there any way to copy a table(structure and data) from mssql to ms access

eaLazerBeam

It is not that simple Access data types are primitive while SQL Server data types are standard, so create a table in Access and use Integrated services to move the data. There is no Integrated services in Express you need to use either the trial or the no deployment developer edition which is under $40 online.
MicHerz
Moved from the C# language group to the .NET Data access and storage group, as that's much more relevant here.

Jon
Sven Loadtester

There is not a built in way to move both data and structure between the two by using ADO.NET. However, you might want to look at the Access upsizing wizard, which will help in moving from Access to SQL Server. To move the other way around, you can use a make table query in Access, and configure the source of data for the query to be a SQL Server.

Thanks,

Erick
Timwright2006

It is true that there might be problems with this approach, and that SSIS is an alternative. However, if you set up a linked server in Access, you can write queries and the providers will convert the data types. At this point, if you make the Access query into a Make Table query, the type conversion will occur automatically. If it fails, you need to use another alternative, but it work for a lot of data types.

Thanks,

Erick
how to Copy a table from mssql to ms access