Importing data

[pakistranger]

HI I would like to design a form where user could be given an option to browse a database .mdb file and then select a table from that database that appears in a combo box and then a query should retreive all values from that selected table. I have tried with recordsset thing but error comes as Type Mismatch for

Set rs = Currentdb.OpenRecordset("strqry")

or when i tried using application.access thing. I still could not retreive list of tables. Thanks very much for suggessions that I am looking forward to.

Cheers

Abid

 

[FoFa]

Set rs = Currentdb.OpenRecordset("strqry")
is the wrong syntax. Take the quotes off strqry (I assume strqry is a variable containing your SQL)

 

[pakistranger]

but Problem is another now

Yep I got rid of it, Thanks fofa but some time we ignore so simple things while trying to do realy complex stuff. Now I am stuck again

when I am trying to count number of records returned through

rst.RecCount
It is printing the wrong value. If I take it within an rst.eof loop the records are more than record count thing shows. Anyone came across this. Please guide