Excel rows to Access columns?

[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.

 

[Guest]

Why not transpose the data in Excel first? Or is it not that simple?

 

[Guest]

Excellent, why can't everything be so simple?

Thanks very much

 

[fredg]

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.

Why not do the change in direction within Excel first?
Select the cells.
Copy

Select an empty cell outside the above range.
Right-click Paste Special + Transpose
Import this range of cells.