Exporting MS SQL 2000 server Table into MS Access 2000 database

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.