Updating ms access database quizzes about dating

Error Message Below : test here db Row is added conn done ! SQLException: General error Here is my source code : int one = Id; String two = Vname; double three = Fuel Cap; String four = Fueltype; double five = Fuel Eff; double six = Range; String seven = Make; String eight = Model; int nine = Year; double ten = LLength; double eleven = LMon Rate; double twelve = Rateper Mile; double thirteen = LCost; double fourteen = Tot Own Cost; double fifteen = CO2Co; double sixteen = N2OCo; double seventeen = CH4Co; String dname = "/AEGV_PGIP_Database_11May12.accdb"; try catch(Exception e) println("conn done ! Jdbc Odbc Statement.execute Update(Jdbc Odbc Statement.java:288) at access_read. Component.process Mouse Event(Component.java:6041) at javax.swing. JComponent.process Mouse Event(JComponent.java:3265) at Event Dispatch Events(Event Dispatch Thread.java:168) at Jdbc Odbc Statement.execute Update(Jdbc Odbc Statement.java:288) at access_read. Component.process Mouse Event(Component.java:6041) at javax.swing. JComponent.process Mouse Event(JComponent.java:3265) at Event Dispatch Events(Event Dispatch Thread.java:168) at Hi I am working on a java program to read from a text file information and update a table withiin a MS Database. Jdbc Odbc.standard Error(Jdbc Odbc.java:7129) at odbc. Event Dispatch Events(Event Dispatch Thread.java:160) at Jdbc Odbc.create SQLException(Jdbc Odbc.java:6986) at odbc. Jdbc Odbc.standard Error(Jdbc Odbc.java:7114) at odbc. Event Dispatch Events(Event Dispatch Thread.java:160) at When I run my program the information is updated in the database, but I get a Invalid Handle error, and Error: (After each database update) Could someone please add some insight, into what the problem could be ? Event Dispatch Thread.run(Event Dispatch Thread.java:121) Error: Event Dispatch Thread.run(Event Dispatch Thread.java:121) Error: The timing and data that's missing is inconsistent.

Component.dispatch Event(Component.java:4243) test here db at Component.dispatch Event(Component.java:4243) test here db at Add("Team", 150) End Sub Public Sub Add() 'SQL STMT Dim SQL As String = "INSERT INTO people TB(N, P, T) VALUES(@PNAME,@POSITION,@TEAM)" cmd = New Ole Db Command(SQL, con) 'ADD PARAMETERS cmd. Open() adapter = New Ole Db Data Adapter(cmd) adapter. Rows Populate(row(1), row(2), row(3)) Next 'CLEAR DATATABLE dt. How can I add the date of death from the excel spreadsheet to my access deceased date section?I'm using Access 2003 This is a general outline of what needs to be done. Update: Ok I've tested, using Excel 2007 but will be basically the same for all versions, and added graphics to show the entire process. I have an Access (2010) tbl Bookings with a Date Completed field.