Selecting specific Table fields with a data connection

[lochem]

Hi all,

i am creating data connections between excel files in order to import tables of data from one file to the next. I have been successful so far at importing and refreshing such imported tables.
however, one of my source tables is quite large and i do not need all of the fields each time i refresh the imported data into the destination workbook. I only need a specific set of fields. is there a way to manage the fields that are imported with a data connection?


using MS Excel 2013 Standard, windows 7 Professional, SP1

Thanks!

 

[lochem]

anyone have any clue as to how to do this?... ray:ray: