Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert column worksheet to database
I have a worksheet containing the following columns; Article No., Article
Group, Article Description and 12 columns representing sales volume per month (Jan to Dec). There are approximately 200 items thus 201 rows. To able to create reports which interact with our accounting database I need to convert the above into access database. Each record would therefore contain Article No., Article Group, Article Description, month and respective volume, thus approximately 12*200 records. Could an excel/access guru advice me on how to do it!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) |