saving columns of a sheet as new sheets and then importing to Access

[DrOktagon]

Hello All,

I have been using my primitive knowledge to try and figure this out for a while and someone directed me here for help. Please help if you can. I'd like to be able to write a macro that does the following.

Saves every column of an Excel sheet as a new sheet (or perhaps a new book), but recopying the first column every time. So sheet2 will have columns 1&2, sheet 3 has columns 1&3, and so on.

Then (perhaps separate macro) imports each new sheet into Access as a separate table.

Reasons:
I have to split it up in excel first because my spreadsheets have ridiculously large numbers of characters in some cells (don't ask) and access has a limit on how many characters can imported in the row of an imported table.

Thanks

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=569898

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).