Looking for a way to move data from excel spreadsheet to access table. I understand the import option, but the data doesn't present itself very well to do it that way.
Row 2 is the "Header" row
Row 3 - 6000 is the data
Column A:J and W:AH need to be written to every row of the table
At this point is where I am having problems Column K:V and AI:AT are month columns
K - V = Jan, Feb, Mar, Apr, etc Data
AI & AT = Jan, Feb, Mar, Apr, etc Data
so the macro I would need would write the following
A3:J3, K3, W3:AH3, AI3 as the first record
A4:J4, K4, W4:AH4, AI4 all the way down to A6000:J6000, K6000, W6000:AH6000, AI6000
then proceed to
A3:J3, L3, W3:AH3, AJ3 as the first record
A4:J4, L4, W4:AH4, AJ4 all the way down to A6000:J6000, L6000, W6000:AH6000, AJ6000
Any suggestion would be helpful.
Stapuff
Row 2 is the "Header" row
Row 3 - 6000 is the data
Column A:J and W:AH need to be written to every row of the table
At this point is where I am having problems Column K:V and AI:AT are month columns
K - V = Jan, Feb, Mar, Apr, etc Data
AI & AT = Jan, Feb, Mar, Apr, etc Data
so the macro I would need would write the following
A3:J3, K3, W3:AH3, AI3 as the first record
A4:J4, K4, W4:AH4, AI4 all the way down to A6000:J6000, K6000, W6000:AH6000, AI6000
then proceed to
A3:J3, L3, W3:AH3, AJ3 as the first record
A4:J4, L4, W4:AH4, AJ4 all the way down to A6000:J6000, L6000, W6000:AH6000, AJ6000
Any suggestion would be helpful.
Stapuff
