use an ADODB data connection:
dim cn As New ADODB.connection
dim rs As New ADODB.Recordset
If cn.state = 0 Then cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DatabaseName;Data Source=."
Last Wiki Answer Submitted: April 7, 2009 10:25 pm by mshen27,310 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hi dis is sabur
i’m having many doubts
pls anyone clear