How would I import the excel sheet like this to Access

[Arvine]

Hi,

I have one excel sheet like this with 2 rows field and I don't know how to import to Access Table.
Thanx

[June7]

Is that an accurate representation of the Excel sheet? Or are the date headers misaligned?

That is not a normalized data structure. If you want to import as normalized data, options:

1. manually rearrange the data in Excel to a normalized structure then use import wizard:
SN City Date Temp

2. VBA code opens the Excel app and file as objects and reads in data one cell at a time

[Arvine]

Thanx for the instant response. The data header was misalligned.

[June7]

Comments still apply.