I am converting an excel based information tool into an Access Database. Each row in the excel spreadsheet has a unique id, but there is a product column that contains multiple products in the same cell of the spreadsheet. Each product is separated with a space and an "&". I have imported the information into access "as-is" and am wanting to know if there is a way to loop through the information I imported into the access table (imported_data) and create a record in a separate table (Products)for each product listed in the product field of the imported data table. (i.e., if there are 3 products for one unique id, I would like to create 3 records in the product table for that unique id.) The record created will contain the unique id and each product the unique id has.

There is, you'll have to create a VB function that will do it for you. I'm in a bit of a pinch right now so I can't do the code, but essentially you want to create a recordset from the table you imported, save the fields values into VB variables, use the VB string functions to parse the '&' delimited field, create a new record in a temporary table for each instance until it reaches the end of the field, then move to the next record. Loop through all the records doing that, then delete the original table and rename the temp table to whatever it is you want it to be known as.