cyborgoddess
Registered User.
- Local time
- Yesterday, 19:41
- Joined
- Sep 2, 2004
- Messages
- 19
I'm posting this here because I'd love to be able to automate an export to excel, where I can use multiple sheets to calculate returns, then import the new numbers back into access as a new table. Is there a way to tell Access to import from a sheet where the fields are made up of 1) The row headers, 2) the column headers 3) the values in the row?
Date 01/01/01 01/01/02 01/01/03
ID
1 $10,000 $10,050 $11,000
2 $11,000 $12,050 $13,000
3 $10,000 $11,050 $12,000
so that the new table looks like:
ID Date Value
1 01/01/01 $10,000
1 01/01/02 $10,050
1 01/01/03 $11,000
2 01/01/01 $11,000
2 01/01/02 $12,050
2 01/01/03 $13,000
Thanks
Date 01/01/01 01/01/02 01/01/03
ID
1 $10,000 $10,050 $11,000
2 $11,000 $12,050 $13,000
3 $10,000 $11,050 $12,000
so that the new table looks like:
ID Date Value
1 01/01/01 $10,000
1 01/01/02 $10,050
1 01/01/03 $11,000
2 01/01/01 $11,000
2 01/01/02 $12,050
2 01/01/03 $13,000
Thanks