Is it possible to take data with all the same fields and put it into another database with the exact same fields, etc. ??? Thanks for your help in advance!!

Yep, it sure is. Look into the DoCmd.TransferDatabase method. That is probably the easiest, but if you need to append data to an existing table, then you may need to use DAO, or ADO, to open the database and insert the data.