Hello everyone,

I want to import only few fields from the excel into the database. i m
using Microsoft access as the backend and vb as the front end.

So far i have succeeded in opening the excel and load the whole excel
data into the database.

i used the following query to load the whole data into the database
table from access.

rs.Open "Test", cn, adOpenKeyset, adLockOptimistic, adCmdTable

but i want only specific fields from the excel, for which i used

rs.Open "select TestA, TestB, TestC from [vbexl$]", cn, adOpenDynamic,
adLockOptimistic, adCmdTable

where vbexl is the excel object. Also, please let me know whether the
query is right or wrong.

please let me know any other way to import only specific fields