PDA

View Full Version : VB Code to extract SQL data on Excel



Slash
06-13-2012, 12:17 AM
Hi,
I am creating a form for users to select employee name and country to provide assigned roles for a particular user

Is there is a sample code that I can grab from someone please. I am looking for a VB code that used SQL statement to extract data from the MSSQL Server and put it on a sheet. The select statement has two parameters (one from dropdown list (country) and the other insert employee names).

Thanks
Slash