G
Guest
I have an Excel spreadsheet that I would like to import into Access but the
structure is incorrect. We have several thousand records that need to be
imported so inputting the info again is not really an option...
EXCEL
Employee Bloggs Smith Jones
Manager Brown Brown Iqbal
Site A B C
Date 15/06/06 15/06/06 18/06/06
ACCESS
Employee Manager Site Date
Bloggs Brown A 15/06/06
Smith Brown B 15/06/06
Jones Iqbal C 18/06/06
Would a Crosstab query be the way to turn the data sideways? If so, I can't
get it to work
Thanks.
structure is incorrect. We have several thousand records that need to be
imported so inputting the info again is not really an option...
EXCEL
Employee Bloggs Smith Jones
Manager Brown Brown Iqbal
Site A B C
Date 15/06/06 15/06/06 18/06/06
ACCESS
Employee Manager Site Date
Bloggs Brown A 15/06/06
Smith Brown B 15/06/06
Jones Iqbal C 18/06/06
Would a Crosstab query be the way to turn the data sideways? If so, I can't
get it to work
Thanks.