M
Mike
Hi All:
I have an imported MS Excel table whose columns are titled:
Date
LocationA
LocationB
LocationC
LocationD
......LocationX
and the cell contents under each "Location" shows a price for each
corresponding date.
I want to "normalize" this into an Access table with the fields:
Date
Location
Price
This is in effect the reverse of a CrossTab Query, but of course, there's no
such query function to do this.
Any ideas how to create and populate this Access table from the existing
imported/linked Excel table, without doing a whole bunch of cutting and
pasting?
Regards,
Mike
I have an imported MS Excel table whose columns are titled:
Date
LocationA
LocationB
LocationC
LocationD
......LocationX
and the cell contents under each "Location" shows a price for each
corresponding date.
I want to "normalize" this into an Access table with the fields:
Date
Location
Price
This is in effect the reverse of a CrossTab Query, but of course, there's no
such query function to do this.
Any ideas how to create and populate this Access table from the existing
imported/linked Excel table, without doing a whole bunch of cutting and
pasting?
Regards,
Mike