1.I want to establish connection with excel and also want to
fetch the data using SQL queries.
2.the code should be written in such a way that in future if
I want to migrate from excel to MS excess database , then
there should be minimal changes.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More VB Script Interview Questions

write a vb script to create a folder?

3 Answers  


who will create the object?

0 Answers   Estuate,


What is the output of a + b in vbscript if a = 5 and b = 10?

0 Answers  


Explain about the asc function?

0 Answers  


Whenever I use Wscript.Echo Qtp raising Run time error as 'Object required for Wscript' How I can create object for Wscript

1 Answers  






How to Import data from a file (file is on the desktop) to the data table

2 Answers   IBM,


Hi, Anybody could tell me What is the 3rd Largest Number in the series..Thanks in Advance..

3 Answers   Amazon, bcbs,


write script to open Gmail.com, and to write script for entering username and password and show whether the result as pass or fail

2 Answers   Thomson Reuters,


Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?

0 Answers  


What is the difference between function and procedure?

0 Answers  


How can we return a value from User Defined Function ? For Eg. we have 2 functions. In Fun1 i am getting 2 values (a,b) and i am addding those 2 and storing in to another var (c). Now i want to pass that var(c) to another function (fun2). What will be the script?

6 Answers   Nous,


We have 1 web page with names column. I am giving the Service Providers1,2,3.... @ that time dynamically some no of names are displaying in the webpage and The Pop up windows are opening(No.of Pop Up windows=No.of Names). The names may be diffar for each and every Service Provders (Dynamically) How can we handle the Dynamic values?

0 Answers  


Categories