16
General Software Discussion / Create a template for converting flat files to Excel or DB
« on: January 25, 2008, 01:21 PM »
The obvious: Working with any Microsoft product SUCKS
... but I have no choice because it is for work and my employer chose MS
The problem: It is a waste of time to set the column widths every time I have to convert the flat files to Excel since there are 76 columns and the width is the same every time.
Question: How do I create a template??
The files are .txt
I know the column width
I can manually set the column widths while converting from .txt to .xls
Can't I create a template to do this?
I keep searching Google and Microsoft but not finding any 'useful' answers
Is there a better place to search???? Or does someone actually know how to do this???
... but I have no choice because it is for work and my employer chose MS
The problem: It is a waste of time to set the column widths every time I have to convert the flat files to Excel since there are 76 columns and the width is the same every time.
Question: How do I create a template??
The files are .txt
I know the column width
I can manually set the column widths while converting from .txt to .xls
Can't I create a template to do this?
I keep searching Google and Microsoft but not finding any 'useful' answers
Is there a better place to search???? Or does someone actually know how to do this???