Can I import data from one Access database to another?

[jimneal]

There are 20 employees that stretch throughout state that record data on damage caused by blasting. Management wants this data in one database however they have no money for a license of either SQL or Oracle. Can't the data from these individual databases be exported as an xml file and then imported into a single collective Access database?

[pbaldy]

Sure; or as an Excel file, delimited text file, etc.

[jimneal]

how can I save it as a delimited file? How would I import it into the main database? I read about amending - would that be the best solution?

[pbaldy]

Look at OutputTo, TransferText and TransferSpreadsheet. You probably mean appending, which is what you would be doing, either by one of the transfer methods or with a query if you linked to the source data.