Hi Tom,

I don't understand what you mean by "it creates a new folder".
To import data into an existing table from an external table with a
different structure, the simplest thing is usually this:

1) use File|Get External Data|Link to link the external table
2) create an append query to move the data from the linked table to the
existing table, with calculated fields to change the field names and
make any other changes.

I haven't used the Business Contact Manager myself, precisely because it
seemed so limited. AFAIR it doesn't offer any extra facilities for
linking Outlook data with relational databases.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

You can very well import an Excel worksheet and add the data to an
existing table!

Make certain that the column headings in Excel are exactly the same as
your field names in the table where you want to put them.
To avoid overwriting existing records, your main field should be indexed,
no duplicates.

Go through: File/Get external data/Import/File type: xls/
Select name of Excel file
Select worksheet
Tick: First row contains titles
Save where?
Existing table
Select table
Confirm

(Some of the terms might be slightly off; I'm using a localized Dutch
version of Access 2000 but you probably get my intentions.)

After that the import should roll. If records are missed or rejected,
that might be because the unique field cannot be overwritten or de data
in some field(s) might be of the incorrect type.

I cannot help you with Outlook as I refuse to use it. I'm a fan of the
Mozilla's. Far less sensitive to corruption through the internet.