Import Excel Files Into Informix

Posted on 1997-09-11
Medium Priority
Last Modified: 2008-03-06
I have files in Excel Format that i wish to upload into informix database. I dun want to export the files into ascii delimited text. please advice
Question by:deantan

Accepted Solution

jantypas earned 100 total points
ID: 1025283
No direct way to do this, but there are a few indirect ways.

1. Take your excell file and save it as CSV format.
   Now with Perl5 and the DBI module for Informix7, you can
   read the CSV, turn it into fields and populate your table.

2. The the Excell material, send it to access and then,
   use Informix ODBC to read Access data.

Author Comment

ID: 1025284
I am actually looking for add-on to informix that does the
conversion .. i am not expecting the excel-user to do any data
thanks very much for your suggestion

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
A method of moving multiple mailboxes (in bulk) to another database in an Exchange 2010/2013/2016 environment...
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question