Find or Extract data from database

[mohan.r1980]

Hello Friends,
i have excel data and i have created a table in database file and add the data.
below code make the database file

Please Login or Register  to view this content.

Now i want to extract this data from database to excel.

i also want to do if i put SrNo in Input box then msgbox will pop up with Client Name.

Please suggest me

[mohan.r1980]

Bump no response

[alansidman]

Create a query in Access using the query wizard and export the query to excel using the export wizard. If this is not something you are familiar with then I suggest you read a tutorial. Here is one that I like to refer new Access developers to.

http://www.accessmvp.com/strive4peace/Index.htm

for your second item, if you are looking for a custom filter, then look at this tutorial

http://www.datapigtechnologies.com/f...tomfilter.html