silentwolf
Active member
- Local time
- Yesterday, 19:23
- Joined
- Jun 12, 2009
- Messages
- 640
Hi guys,
unfortunatelly I can not figure out what I am missing or doing wrong with following SQL String and it feels like I tried all but am not able to get it run without errors.
I like to Create a Table from an Existing Table ..
Can someone please check my SQL String?
Many thanks
Albert
unfortunatelly I can not figure out what I am missing or doing wrong with following SQL String and it feels like I tried all but am not able to get it run without errors.
Code:Public Sub CreateFromExistingTable(selectTable As String, intoTable As String) Dim strSQL As String strSQL = "SELECT " & selectTable & ".* INTO " & intoTable & "FROM " & selectTable & """" CurrentDb.Execute strSQL, dbFailOnError End Sub
I like to Create a Table from an Existing Table ..
Can someone please check my SQL String?
Many thanks
Albert