Export tables from SQL to Access

[danasegarane]

Dear Gurus,
How can Export the tables from SQL DataBase to Access database

Thanks in Advance

 

[Arg81]

Are you asking how to do this in code, or in general?

I ask because you can simply use the Export function in SQL Server Management Console...

 

[VBStarterKid]

Hi there, I have a similar question here, but I'd like to know how do I programmatically copy a certain table, with its structure and data, from SQL Server database into MS Access, using ADO.Net.

I would like to be able to write a vb class file that can accept a table name as a parameter, so that I could re-use the script to copy any table, with its structure and data, from SQL Server to MS Access whenever the need arises.

The reason is because I have a test application which requires ad-hoc test data from Access tables.

Thank you in advance.