extract sales data out of a text file and import in to either MS Access or MS Excel

Good afternoon,

I am in need of some direction. My company currently utilizes a software program to extract sales data out of a text file and import in to either MS Access or MS Excel. The version of this software we are using is not compatible with Windows 7 and we are faced with the considerable expense of updating the licenses of all users when they upgrade to the new OS. Hopefully your company can provide a solution.

It looks like the Data Exchange Wizard most closely replicates the software we are currently using – with one exception. We need the exported file to be in .xlsx, not the listed database formats (Oracle, MS SQL, Etc). The option to have different configurations pre-loaded and distributed to the users is a real plus for us, thereby enabling users with little computer expertise to perform the conversion. Getting past the “Target Configuration” to just export the data to .xlsx would be the key for us.

We hope this is something your company can help us with – if you need further information, please let me know. Thanks!

Greg

Greg

Sure, we will be happy to assist you.
Can you email s couple of examples please

Mike

Mike,

Thanks for examples

The results of the Transformations look very encouraging. Can we save the mapping portion and simply run the transformation on a file or do we have to re-map it each time we need to convert a file?

Greg

Greg

ATS file holds the mapping you can copy it save it or save as it
If you want to transform different file you can just point reader object to another file.
So you do not need to remap it.
Or am I missing something?

Mike