Well, i have a problem that i dont see an easy fix too. I have an excel spreadsheet put together by a co-worker that needs to be imported into a newly created access database.
The problem lies in the way the data was input into the spreadsheet. Basically, it's a mess. Each tab is an individual store number. Within the tab there are several columns that contain various store info fields.
however when changing from tab to tab the field names (although referring to the same thing) may be spelled differently, in different order, etc.
the reason im stretching so far out on such a long limb is because if i dont find some way to import this data (or manipulate/group it in Excel somehow) I will be spending hours manually entering in each record.
The problem lies in the way the data was input into the spreadsheet. Basically, it's a mess. Each tab is an individual store number. Within the tab there are several columns that contain various store info fields.
however when changing from tab to tab the field names (although referring to the same thing) may be spelled differently, in different order, etc.
the reason im stretching so far out on such a long limb is because if i dont find some way to import this data (or manipulate/group it in Excel somehow) I will be spending hours manually entering in each record.