I am trying to use the below code to transfer the data in to access database. but I am getting an error like
"the INSERT INTO statement contains the following un known field name:'F12'.Make sure you have type the name correctly and try the operation again. I already check the fields name in database and in excel also
Dim cn As Object
'//I am using late binding for creating objects, this code will run on any version of Excel
Set cn = CreateObject("ADODB.Connection")
' //This line will set the path of Ms.Access database, in this case it is assumed that Ms.Access DB will be in same folder as in Excel File.
dbPath = Application.ActiveWorkbook.Path & "\SDOD.mdb"
' // This line will set the path of Active workbook
dbWb = Application.ActiveWorkbook.FullName
'// Get the Active sheet name, so that we can correctly Export data using this variable
dbWs = Application.ActiveSheet.Name
'// Set the connection, we are creating Excel workbook connection
scn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath
' //Another variable to hold worksheet name, but in this case it will //be in a format that is required to pass in open connection //method, which execute the SQL statement in next line
dsh = "[" & "Sheet1" & "$]"
'// Open the connection
'//Create SQL statement using proper sheet name dsh, created //before opening connection
ssql = "INSERT INTO Candidate ([Source],[C_Name])"
ssql = ssql & "SELECT * FROM [Excel 8.0;HDR=YES;DATABASE=" & dbWb & "]." & dsh
'//Run the SQL