Re: Inserting records into Informix using MS-ACCESS

Peter Marley wrote: > > Help, > > I am trying to use MS-ACCESS to insert records from an MS-ACCESS table into > an Informix table on a UNIX server. I keep hitting a brick wall. > > I have a feeling that this action is not functionally possible within > MS-ACCESS. > > I can get MS-ACCESS to update records in an Informix table using an > MS-ACCESS table as the source, but every time I try and insert using a > pass-thru query, MS-ACCESS sends the whole query to Informix. Therefore, > Informix is trying to insert records from an Informix table that does not > exist, instead of MS-ACCESS passing it the data. > > The export option in MS-ACCESS does not work either. My ODBC does not > support this feature (OpenLink) > > It seems my only option is to create a delimited text file from the > MS-ACCESS table and FTP it across. > > Any help would be appreciated. > > -- > Peter > __________________________________ > Peter Marley > DBA, Acco UK Ltd > Tel: +44 (0)1296 397444 ext. 4098 > Fax: +44 (0)1296 311019 > email: peter.marley@acco-uk.co.uk Hi Peter One of the databases we use over here to record our info happens to be Informix, with an Access front end (with OpenLink drivers, of course). I routinely export whole tables from Access to Informix without a problem. Hence my surprise at your statement that OpenLink does not support this feature. If you would like to send me details of the problems you are having, I will be able to help you. Best Regards Mike Aslan OpenLink SOftware