Let me think about that ..

How about -

dim sql as string
sql = "select tablename.* from tablename limit 5" 
' other things you'll need are defined elsewhere in your program

Now, you'll need to add the code that connects to mysql, then open the recordset and show the results to the user. There are About 2,070,000 results returned(0.12 seconds) for this question in Google.

:) it's been a really slow day ..

tnx for the reply..
i need to ask different thing. :)
how can i loop through a listview and display the
items to a specific cell in excel???

already done.. :-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.