Community discussion forum

INSERT INTO (mode connecté)

• • Reply

  2 months ago

  by vb2005learning

  Paul MERTENS

  MONS, Belgium

  Joined 2 months ago

  Hello, I am learning VB2005 How can i insert a date (with a variable date) in an existing table (MSAccess)

  dim varDate as date dim cmd as oledbcommand cmd= new oledbcommand cmd.connection=con cmd.commandtext=" insert into MaTable (date) values (" & varDate & ")" ----> does not work !!! cmd.commandtext=" insert into MaTable (date) values ('" & varDate & "')" ----> does not work !!! cmd.commandtext=" insert into MaTable (date) values (#" & varDate & "#)" ---> does not work !!! cmd.executenonquery

  Thanks for your help .

  Post was edited on 22/09/2009 08:56:01 Report abuse