Access linked tables not updating
It looks up values in the User Information list, so you must decide whether you want to import the User Information list along with other lists.
Columns containing rich text formatting are imported into Access as Memo fields.
Access does not automatically create relationships between related tables at the end of an import operation.
The steps for setting the lookup properties of such a field are described under Set lookup fields in this article.
When you import data, Access creates a table and copies the columns and items from the source list (or view) into that table as fields and records.