Importing Data to a Template
more data on that...
turns out it's actually more of a "Text to Columns" that is wanted.
The data, in a file called *.xls, is in an unformatted structure, with a
tilde ~ delimiter.
What is wanted is a template oriented method of getting the ~ delimited data
into it's true column structure, with all fields in text format.
I wrote a simple program to accept the file name, open the file, and use
TextToColumns to format it, but the user would prefer a true template
approach, if possible.
|