Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Question Unanswered: Text file upload to Informix database

    Hi to all informix guru's out there,

    I have a text file extracted from an excel spreadsheet application w/c I need to upload to informix database. Is there a way to do this directly, and what do I need? Also, if there is such a process, can this be automated such that it picks up the a standard file from a shared file and uploads it automatically. I'll be right back with the version of the informix database that we are currently using. Thanks for taking time out to provide feedback, appreciate it.


    Have a good day....

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    You can configure to access your Informix Database directly from Excel with ODBC. But I don't know if is possible to execute inserts.

    If your server is a Linux/Unix OS, with shells scripts you can do this.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •