Forum Discussion
Import Access fields that allow multiple values from lookup
There are three fields which contain multiple values. I solved the problem creating three Access queries on the primary key, date, and each field value (field.value) individually. I downloaded these queries in BI which gave me the information I needed in the correct format. Thanks for your assistance.
OK, I think I understand. So it sounds like these columns are not scalar values, but instead a table of values. Is that correct? Can you write a query in Access that expands the data into multiple columns or other tables?
There are three fields which contain multiple values. I solved the problem creating three Access queries on the primary key, date, and each field value (field.value) individually. I downloaded these queries in BI which gave me the information I needed in the correct format. Thanks for your assistance.