Hi all,
I am importing from excel
The part number field may have multiple part number
Then you open it in excel and wrap the text, you can see the part number in separate line
In access, it is one long string with no separators
Please could you advise how to have these part numbers separated by comma in a query
I am importing from excel
The part number field may have multiple part number
Then you open it in excel and wrap the text, you can see the part number in separate line
In access, it is one long string with no separators
Please could you advise how to have these part numbers separated by comma in a query