Excel rows to Access columns?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

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.
 
Back
Top