Here is what I have tried thus far. I am getting error as described
beside the appropriate line  in the code:

'Create and open connection.
        Dim ssceconn As New SqlCeConnection("Data Source = \Program
Files\data\projects\" & Me.Text & "\" & Me.Text & ".sdf")
        ssceconn.Open()

        Dim strIn As String
        Dim strOut As String

        strIn = "\Program Files\data\projects\" & Me.Text & "\" &
Me.Text & ".sdf"
        strOut = "\Program Files\data\tabs\header\spec.sdf"

        Dim sqlImport As New SqlCeCommand("SELECT * INTO
strIn.dbo.[tblHeader] FROM strOut.dbo.[tblHeader]", ssceconn)
        sqlImport.ExecuteNonQuery() - There was an error parsing the
query. [ Token line number = 1,Token line offset = 10,Token in error =
INTO ]

        ' Close the connection
        ssceconn.Close()
        ssceconn.Dispose()
        ssceconn = Nothing

        engine.Dispose()
        engine = Nothing
        Beep()
        MsgBox("import done")