I would suggest that you use a make a table query. Create a new query in design view, and then click the Query Type icon in the toolbar and select Make table and enter a table name and select the option Another Database. Then select the fields you want to export. When this query is run it will make another table in the database you specify.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
