Multiple Columns for same field
Posted on 2006-11-20
I tried asking this before - it seems I might have stumped the experts. I'll try again.
On an Excel spreadsheet, I have multiple columns for ProductOrdered for each customer - this spreadsheet is given to us from our customer from their website download. What's the best way I can import this into my Access database? - it has an Orders and an Order Details table that is very similar to the Northwind database tables.
Here's what my Excel spreadsheet looks like:
Order Number CustomerName Address City State ProductName Qty ProductName Qty
1023 Sarah Jones 123 Main St Birmingham AL Welcome Basket 1 Thankyou Basket 2
1024 Bob Wallace 542 23rd St Chicago IL Thankyou Basket 1
How would I pull in the Order Details and Order information into my database?
Any assistance would be greatly appreciated!