I am in need of some VBA code to import and convert data into an Access multi-value field.
Yes, I know I should not be using them but I have no choice. I work in ecommerce and I get CSV exported data in the following format:
"Red Widget", "1,3,5"
"Blue Widget", "3"
I need to run data analysis on our store so I need to bring in the data and create the relationships. I will also need to eventually export the data in the same format which is why I am staying with the multi-value field. Since I cannot import into a multi-value field I figured this method would work:
1. Import the Products into a temporary table: _tblProducts
2. Using VBA code, append the data to a Products table and at the same time populating the multi-value field with the category IDs.
So I'm looking for the code that will cycle through _tmpProducts and append the data to the table Products while properly filling Products!CategoryIDs multi-value field.