how to select from a odbc database?

[gbfell]

i need to run the following code in vb

insert INTO ACOMPARTMENT select DB2ADMIN.ACOMPARTMENT.* from DB2ADMIN.ACOMPARTMENT IN 'DEMO';

its obviously not working because the 'demo' is the name of the DB2 ODBC datasource, not the path per say. how can i do this?

 

[vb5prgrmr]

I believe (could be wrong) that all you need to do is remove the "IN DEMO" from your query string

insert INTO ACOMPARTMENT select DB2ADMIN.ACOMPARTMENT.* from DB2ADMIN.ACOMPARTMENT IN 'DEMO'

insert INTO ACOMPARTMENT select DB2ADMIN.ACOMPARTMENT.* from DB2ADMIN.ACOMPARTMENT

It's just a guess (w/info given) but worth a try.

 

[gbfell]

any other ideas? i want to insert into an access db, from an ODBC DB2 db.