get syntax error when loading data to a informix database

Hi I have ids 9.4 oon windows and csdk. l successfully connected to the database using Visula Basic 6. When l build a string for example SQL1 = "select * from hse2 where field1 matches " & "'a*' and execute using : DbaseConn.Execute (SQL1) it works fine. When l try to load data to a table : SQL1 = "load from " & " 'd:\\x.unl' " & " insert into hse2" or SQL1 = "load from 'd:\\x.unl' insert into hse2 I get a syntax error -201. Anyone know why. Thanks in advance Umesh

"Umesh" <commbtp@lineone.net> wrote in message news:90d5e433.0412190429.d03c7fb@posting.google.com... [CLIPPED] > > When l try to load data to a table : > SQL1 = "load from " & " 'd:\\x.unl' " & " insert into hse2" > or > SQL1 = "load from 'd:\\x.unl' insert into hse2 > > I get a syntax error -201. Anyone know why. > LOAD FROM is *not* a SQL statement! It is a feature (extension) of dbaccess utility and maybe some others. Gorazd