Console application in VB2005 to insert record into MS Access 2003.

I am using VB2005 and Access 2003.

I need a snippet of code for Visual Studio 2005 for a console
application to insert a record into Access 2003.

I want to insert data from a flat file to an existing MS Access table.

Can someone supply the code to do this. I can read from the flat file
without a problem, but need the code to insert into MS Access. I
already have a data connection that is in the Database explorer that
points to the correct table in access. It is defined as:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source = c:test.MDB

The table name in Access is called NewTable and the field is called
FieldA.

I don't want to display any response to the user, so I want this to be
a console application.

Thank you for your help.

- larryTAKEOUT%40seldin.net">larryTAKEOUTseldin.net

Messages in this topic (1) Reply (via web post) | Start a new topic

.