Forum Discussion

EricFromNorCal's avatar
EricFromNorCal
Copper Contributor
Oct 28, 2024

How can I save a fixed field definition when importing into Excel?

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.

3 Replies