.XLS ->Delimited all in AMS??

[kpsmith]

Any creative thinking person know of a way to convert an excel spreasheet to a tab or other delimited file withing AMS.

I'm reading in data to an AMS project from a spreadsheet by haviing a user save as a Tab delimited .TXT file right now and I'd like to find a way for AMS to handle that conversion and save the user the extra step

[Worm]

Re: .XLS ->Delimited all in AMS??

Is Excel installed on the machines that will run the AMS app? If so, I wonder if it could be performed through Automation.

[kpsmith]

Re: .XLS ->Delimited all in AMS??

Yep, I'd assume so. That's an idea I hadn't thought of yet....

I'll look into it. Thanks Worm