It might look something like this...
VB Code:
  1. INSERT INTO india [IN news.mdb] SELECT india.* FROM india