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!
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…