I have tried exporting tables from Access to Dataverse, but the relationships never get exported. The only thing that gets exported are the tables. So, now in Dataverse, I'm trying to create the relationships but I can't because it only allows me to create 'new' lookup columns. I only have 3 tables, but one of them has 160,000 rows. I know people have asked this in the past, but there still doesn't seem to be an answer to this. How can we create the relationships between tables with existing columns? I tried recreating the table, adding the lookup column, and then importing the data. But Dataverse doesn't allow me to enter data in the newly created lookup column. There has to be some way to get this working.
Any help would be appreciated.