I need to import data from 150 excel spreadsheets into a table. I only need to pull columns A, G, K I can supply the filename of each spreadsheet. What syntax can I use to accomplish this?
I was going to use the gateway interface, but the spreadsheets have almost all possible columns populated. Unclicking these is going to take forever! If I could start the interface with the columns all unchecked it would be easy. Any suggestions? Thanks, Dennis McGrath
