How do I append my one Access dbase with data from many different.

[Guest]

I have one Access dbase table. I am trying to move many different xls files
into the one table. If I have data in the dbase table and "import" data from
an xls file, it wipes out the existing dbase information.

Thank you for any help you can give me.

 

[Joan Wild]

I have one Access dbase table. I am trying to move many different
xls files into the one table. If I have data in the dbase table and
"import" data from an xls file, it wipes out the existing dbase
information.

You can link to the xls files, and then run append queries to add the data
to your table.