Excel to access

rchristie11

New Member
Joined
Sep 14, 2002
Messages
1
I'm trying to import data from several excel sheets into access. The problem is that the column headings in the excel files are identifiers, and should themselves be included in a field.

i.e: I have an excel table like this
1 2 3
a x x x
b x x x
c x x x

but want it in access like this:
a 1 x
a 2 x
a 3 x
b 1 x
b 2 x
etc....

Any quick way to do this without a lot of manual copying/pasting etc? It's quite a bit of data over many sheets....

Thanks,
- Rich
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,457
Members
412,595
Latest member
slim313
Top