INSERT INTO Syntax Error (1 Viewer)

Learn2010 · Oct 11, 2018

Can anyone tell me why this doesn't work?

DoCmd.RunSQL ("INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _
& "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _
& "FROM tblLogin"

Thank you.

isladogs · Oct 11, 2018

Add spaces at the start of each line,
Remove left bracket after RunSQL, move the quotes after DB at end of line 1 and remove the single quotes around DB in line 2

Apart from all that .... I think its OK!

Code:

DoCmd.RunSQL "INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB )" & _
       " SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS DB" & _
       " FROM tblLogin"

Learn2010 · Oct 11, 2018

That worked. Thanks very much.

isladogs · Oct 11, 2018

You're welcome

Gasman · Oct 11, 2018

If you build the sql to a string variable, you can then Debug.Print it.

That is the way I tend to find a lot of my errors in SQL.

Code:

Dim strSQL as String
strSQL = "INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _
& "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _
& "FROM tblLogin"
Debug.Print strSQL

DoCmd.RunSQL  strSQL

Learn2010 said:
Can anyone tell me why this doesn't work?

DoCmd.RunSQL ("INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _
& "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _
& "FROM tblLogin"

Thank you.

INSERT INTO Syntax Error (1 Viewer)

Learn2010

Registered User.

isladogs

MVP / VIP

Learn2010

Registered User.

isladogs

MVP / VIP

Gasman

Enthusiastic Amateur

Similar threads

Users who are viewing this thread