Want to split large text file into multiple excel spreadsheets by column.
The end goal is to parse the file so it can be uploaded to Access 2013 which limits the number of columns in a table to 250.
I would like to know how to:
1.) use the field layout to turn the text file into a tab separated text file
2.) how to split the file by columns and insert each section of columns into a separate sheet inside the existing workbook.