Exporting MS SQL 2000 server Table into MS Access 2000 database

Question

Hi Folks I'm having problems in exporting an SQL server table into MS Access 2000 database.... Actually i want to do it in my vb.net codes... It's a great help if someone could send a code on how to this. Your help is very much appreciated... God bless! Reivax2377

Jan Montano · Answer

If only both your servers are SQL it wouldn't be that hard. But in your scenario one is sql and one is access. I don't know if we can have a single query to directly put your query from sql to access. But what I will do as workaround is querying my sql and then opening a connection to ms access and manually inserting the results of my query.

Reivax Sevy · Answer

Hi I really hope someone out there could help me on this. Here's the scenario example i have a sql statement like this: select customerid customername telephon from tblCustomers then i want to export the result of this into a Microsoft Access DB. what would be the best code for this? Thanks a lot guys. Reivax