Re: inserting records from MS-ACCESS

Peter Marley wrote: > > Help, > > This is the second attempt at posting so apologies if two messages appear. > > I am trying to use MS-ACCESS to insert records from an MS-ACCESS table into > an Informix table on a UNIX server, using an ODBC. > > I have a feeling that this is not functionally possible within MS-ACCESS. > > I can successfully update an Informix table from an MS-ACCESS table, but > when I try to insert records the whole query is sent to Informix; so > Informix is trying to insert records from an Informix table that does not > exist. I was hoping that MS-ACCESS would pass the data to Informix as part > of the query. > > I have tried the export option in MS-ACCESS, but my ODBC does not support > this feature. > > I have a feeling that I will have to generate a delimited text file and FTP > it to the UNIX server, which will be a pain as I want to automate the whole > thing. > > Any help would be appreciated. > > Peter > > -- > 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