Getting Error in text data type

LilyMarie · #1 06-09-2009, 05:06 AM

Hello everyone,

Not getting text data types.

I have use this code :

Code:

Private Sub Command6_Click()
Dim ssql As String
ssql = "insert into table1(name,rollno,reason) values('" & Text0.Value & "'," & Text2.Value & ",'" & Text4.Value & "')"
DoCmd.RunSQL ssql
End Sub

bhill · #2 06-09-2009, 07:53 AM

try this:

Code:

ssql = "INSERT INTO Table1 ( name, rollno, reason )" & _
        " SELECT '" & Me.text0.value & "' AS Expr1, '" & Me.text2.value & "' AS Expr2, '" & Me.text4.value & "' AS Expr3;"

LilyMarie · #3 06-15-2009, 07:08 AM

Hi,

Thanks for your reply this code works perfectly.

Thanks once again.

Welcome to the Excel Forum

Forum Statistics