I frequently need to import the same fixed field file into Excel every week.

During the Open operation, I’m selecting a text file. I’m presented with a window to select the heading column, the row# where the data starts, and the column breaks.

Where is this definition stored?  How can I automatically apply it?

When searching the web, I found several articles that say that the definition is saved in the spreadsheet, but I can’t figure out how to apply it.  Every time I try to import a new flat file – Excel does not use the existing sheet – it opens a new sheet – so whatever column breaks and data row# exists in the spreadsheet does not in the new one when I chose Open. 

Please see attached redacted sample of the dialog I’m talking about.

I understand I can define and save a data source.  I was wondering if the import functionary has this capability as well.

Any help would be greatly appreciated.

​I frequently need to import the same fixed field file into Excel every week.During the Open operation, I’m selecting a text file. I’m presented with a window to select the heading column, the row# where the data starts, and the column breaks.Where is this definition stored?  How can I automatically apply it?When searching the web, I found several articles that say that the definition is saved in the spreadsheet, but I can’t figure out how to apply it.  Every time I try to import a new flat file – Excel does not use the existing sheet – it opens a new sheet – so whatever column breaks and data row# exists in the spreadsheet does not in the new one when I chose Open.  Please see attached redacted sample of the dialog I’m talking about.I understand I can define and save a data source.  I was wondering if the import functionary has this capability as well.Any help would be greatly appreciated.  Read More

​