Share via

Export Access tables to SharePoint list

Anonymous
2022-04-04T14:13:39+00:00

I have built a database using Access which has several junction tables. When I try to export those tables to SharePoint, I get the following message (see below). The data types in all of my junction tables are 'Number' relating to the primary key of it's separate related table (see image below). Do I need to do anything differently to export these to SharePoint or is it not possible?

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-05T18:52:28+00:00

    I assume I do this only to my junction tables, and to both GuardianID and ConsumerID, correct? Like this:

    0 comments
  2. George Hepworth 22,220 Reputation points Volunteer Moderator
    2022-04-05T19:58:12+00:00

    Actually any table with a Foreign Key in it in Access.... Replace that with a Lookup to the table from which the Foreign Key comes.

    0 comments
  3. Anonymous
    2022-04-06T15:03:35+00:00

    I'm not sure why, but every time I export a junction table or any table that has a relationship by foreign key, it also exports the related table, thus creating duplicate list, for example I end of with Consumers, Consumers_1, Consumers_2 and so on. So what I've done, and I hope this is the correct procedure; delete the foreign key columns in the junction tables and create new ones based on the directions you provided earlier. Then I delete the duplicated list. Is this correct?

    0 comments