Informix

[sqluser1349]

We are trying to import a table from a international client. Their data has a table description file and then each individual table has a file for its records.
Each file is in a .amfm format. It is not possible to vpn or set up a odbc connection.

The table description is as follows:
{ TABLE "***".businesssize row size = 100 number of columns = 4 index size = 0
}
create table "***".businesssize
(
id integer,
employees varchar(50),
city char(30),
job_code char(15)
) extent size 16 next size 16 lock mode page;
revoke all on "***".businesssize from "public";

The "***" is the name of the comapny. It can be replaced with any string. Any Ideas?

 

[Pat Hartman]

If there is no ODBC driver that can be used to read the Informix table, you are SOL unless you can export data from the Informix table to a .csv or .txt file or something else that Access can read.

 

[WayneRyan]

sql,

Need more info here.

Is this a one-time shot?

How many tables are there?

If there are a lot of them, it shouldn't be too difficult to
read one with VBA and change the Create Table to something
that Access can digest. But there are data conversions;
varchar --> Text, Char --> Text, IDs Integer --> Autonumber.

They don't specify any indexes, how can you export an index?
And they don't identify Primary Keys.

The code that generates the Create Table script can trigger
the import can either: parse the 2nd file, or generate an
input specification and let Access read it.

Unless you're really familiar with VBa, I'd suggest that
you manually create the tables/input specs. UNLESS there
are a LOT of tables.

One last comment, the absence of PKs and indexes can make
a big difference when moving to a new platform. Informix
is a database, and a few queries can get you that information.
That could be very nice to have.

After typing all that, I googled JDBC & Informix & SqlServer

http://www.google.com/search?hl=en&lr=&c2coff=1&q=jdbc+"sql+server"+informix

Wayne