K
KWhamill
I have a spreadsheet that was once converted to Pivot Table, copied and
pasted and then never changed back. The original source of this data is gone.
and i need to convert this into an access table. Thus I have something that
looks like this
Date1 date2 date3 date4
date5 date6
1 amt amt amt amt
amt amt
2 amt amt amt amt
amt amt
3 amt amt amt amt
amt amt
So I want to make each of those into an individual entry on a table
primary key 1 date1 amt
primary key 1 date2 amt
and so on
the amount of data is enormous I can't see just entering these in, but i
can't think of a way to unravel the spreadsheet.
pasted and then never changed back. The original source of this data is gone.
and i need to convert this into an access table. Thus I have something that
looks like this
Date1 date2 date3 date4
date5 date6
1 amt amt amt amt
amt amt
2 amt amt amt amt
amt amt
3 amt amt amt amt
amt amt
So I want to make each of those into an individual entry on a table
primary key 1 date1 amt
primary key 1 date2 amt
and so on
the amount of data is enormous I can't see just entering these in, but i
can't think of a way to unravel the spreadsheet.