Access tables

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

How would I write a query that would allow me to DROP a
table in a seperate database?

Thanks,
Chad
 
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.
 
Back
Top