nickjones87
New member
- Local time
- Today, 23:30
- Joined
- Oct 21, 2009
- Messages
- 6
Hi,
I'm importing orders into Access 2002, the csv file is from eBay. I've stumbled into a problem with orders with 2 or more different products for each sale.
I've attached a picture so it's easier to understand my problem.
As you can see, rows 3-5 and 20-25 contain multiple products.
Once this file is imported into access, each row gets its own record, what I want is for orders like this to be appended to just one record in access
EG, I have fields Product Name 1, Qty1, Product Name 2, Qty2, Product Name 3, Qty3, etc in my database, so ...
row 4 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 1" & "Qty1" in my database on the same record.
row 5 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 2" & "Qty2" in my database on the same record.
And so on....
The only unique identifier is the first column in the screenshot "Sales Record", rows 3 to 5 and 20 to 25 have the same Sales Record.
Is there a simple way of doing this?
Thanks guys!!
I'm importing orders into Access 2002, the csv file is from eBay. I've stumbled into a problem with orders with 2 or more different products for each sale.
I've attached a picture so it's easier to understand my problem.
As you can see, rows 3-5 and 20-25 contain multiple products.
Once this file is imported into access, each row gets its own record, what I want is for orders like this to be appended to just one record in access
EG, I have fields Product Name 1, Qty1, Product Name 2, Qty2, Product Name 3, Qty3, etc in my database, so ...
row 4 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 1" & "Qty1" in my database on the same record.
row 5 "Item Title" & "Quantity" in the screenshot would be appended to "Product Name 2" & "Qty2" in my database on the same record.
And so on....
The only unique identifier is the first column in the screenshot "Sales Record", rows 3 to 5 and 20 to 25 have the same Sales Record.
Is there a simple way of doing this?
Thanks guys!!
