PattiP, could you supply a short sample of your table?
--
Sincerely, Michael Colvin


"PattiP" wrote:

I have a spreadsheet for hourly energy sales and purchases. The hours are
horizontal with all the entries below in rows. I would like send this data to
Access for after-the-fact reporting. However, I would like to have a single
date/time field so that each of the hours is a record rather than have a
field for each hour. Is there a way to get the Excel data into a useable
format to transfer the data into Access?

Patti