By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Transferring Information from excel to SQL

P: 1
My question is concerning “Recordsets”. Currently I am receiving some information in Excel and I would like to transfer that information into SQL database.
From my understanding I need to setup up a connection (currently using ADODB for my connection) . I am unaware of how to get the information from Excel into the” Recordset” (either by copying or other methods) and sending it to my SQL database. I’m fairly new to this, do you have any suggestions??
This is what I have so far…
Dim rs As ADODB.Connection
Set rs = New ADODB.Connection
Dim strConn As String
strConn=” PROVIDER=SQLOLEDB;"
strConn = strConn & "DATA SOURCE=MRPSERVER\ATE;INITIAL CATALOG=ATEstrConn = strConn & "INTEGRATED SECURITY=sspi;"
Dim rsDB1 As ADODB.Recordset
Set rsDB1 = New ADODB.Recordset

The above code has not worked for me..

2) I am not able to add a "project reference" I always get a registry error. I've searched online for solutions but not able to find one. Which further makes me question if I have Microsoft.JET.OLEDB.4.0 (I've seen most connections use this driver)
3) I also need to address the Loop within the Recordset. since the recordset will represent a value/position and receiving the information in the Excel file I have several columns
Dec 2 '13 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.