Hi,

I am new to this type of forums. I am not sure if i should be asking this are not. Or even if i am asking at the right place. If i have made a mistake you can delete the thread if u want to.

I need to do a VB Scripting in Excel Worksheet such for the following process.

User will enter a string in the Text field. And clicks a button.

When the button is clicked the vb script should match the string to a column in a View in SQL Server and return the corresponding datas which have the same value as the textfield.

For example

The following is the data found in the SQL View

Product Type Qty Date
Mango Indian 20 9/5/2014
Apple Fuji 30 7/5/2014
Mango Thailand 40 8/5/2014


In the Excel sheet when the user enters Mango in the text field and clicks the Button the following data should be displayed in the Excel sheet.

Product Type Qty Date
Mango Indian 20 9/5/2014
Mango Thailand 40 8/5/2014


I am good in C++. I can easily do this using Gui forms and ASP.NET. But i dont know VB. But i need this to be done in Excel VB as the users wants it in Excel. So can Someone please Help.


Thanks,

Ramya

If it will make things easier, I can extract the whole data from SQL and place it in the Excel using Data extract in a seperate sheet. And then from there it is possible to the VB scripting for the above process. Instead of connecting to SQL and retrieving data from there.

I hope this might make it easier for you. Thanks for the help.

Hi Ramya

It would've been much simpler if you connect from .NET to SQLServer / Oracle . Excel also does more or less the same

The following link should be useful for your requirement

http://www.mdobie.co.uk/2012/11/14/q...ith-excel-vba/

To extract data from SQL Server Table to Excel

http://office.microsoft.com/en-in/ex...010217956.aspx


If you want to use Excel as a Database (Table). Refer the link below

http://vbadud.blogspot.in/2008/05/us...-database.html



Regards
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)