HomeForum
Welcome, Guest

Text to Excel Conversion
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Text to Excel Conversion

Text to Excel Conversion 1 year, 7 months ago #1027

  • Joseph
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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!

Joseph

Re: Text to Excel Conversion 1 year, 7 months ago #1031

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Joseph

I do not think that Data Exchange Wizard is what you need.
It can only export data into text files at the moment
I think Advanced ETL processor would be the most suitable solution.

Mike
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

Within an hour we were able  to populate fact and dimension tables in our datawarehouse using Advanced ETL Processor

P. Jonson

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top