I am unable to insert into the access database. I have a
windows form application under vb.net and am using
ado.net to try to INSERT new entries into my database.
However, I keep getting errors. I would appreciate if
someone could help me out here.

Code snippet below.

Dim conn As New OleDbConnection()
conn.ConnectionString = connect

Dim insertStr As String = "INSERT INTO finaldb
course,lname,fname,ssn,emailid VALUES infoArray
(4),infoArray(0),infoArray(1),infoArray(2),infoArray(3)"

Dim cmd As OleDbCommand = New OleDbCommand()
cmd.Connection = conn
cmd.CommandText = insertStr

conn.Open()
cmd.ExecuteNonQuery()
conn.Close()

I would appreciate any help.

cheers
John

Cheers,
Maartin.

An unhandled exception of
type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll

cheers
John

An unhandled exception of
type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll

cheers
John

dim sql1 as String = "INSERT INTO finaldb ( course,
lname, fname, ssn, emailid ) VALUES (four, zero, one,
two, three);"

and it still doesn't work.  I run this query in the SQL
view of access and it works fine. Is there something else
I am missing.

My problem stems from obtaining strings dynamically and
then storing them into an array and then trying to insert
the array i.e. somearray(0), somearray(1) adn etc into
the database via an insert statement.

Do you know of a way to insert variables/arrays into
access database?  This is my problem. The code works fine
when I use string literals but will not work when I use
variables.

any suggestions.

best regards,
John

here is the error message

An unhandled exception of
type 'System.Data.OleDb.OleDbException' occurred in
system.data.dll

There is usually some additional more specific information than what you posted. Could you check
again and post if there is any additional error info?

Microsoft MVP (Visual Basic)

dim sql1 as String = "INSERT INTO finaldb ( course,
lname, fname, ssn, emailid ) VALUES ('four', 'zero', 'one',
'two', 'three');"

So your original insert should be something like:

Dim insertStr As String = "INSERT INTO finaldb
course,lname,fname,ssn,emailid VALUES('" &  infoArray(4) & "','" &
infoArray(0) & "','" & infoArray(1) & "','" & infoArray(2) & "','" &
infoArray(3) & "')"

Those deleimters are " ' , ' "

You want the string resolved with single quotes around your variables
(assuming they are strings).

Joe Maki