R
rebelscum0000
Dear All,
Can some one provide me with an example How to Make-Table Query to
create the Table including the required data in one-step?
Lets say I want FileName set to "Readme" , FileExtions set to
".txt" and MyInclude set to "-1"
This is my SQL:
sQL6 = "SELECT MainExclude_Tbl.ID, MainExclude_Tbl.MyKeyword, " & _
"MainExclude_Tbl.MyAppz, MainExclude_Tbl.FileName, " & _
"MainExclude_Tbl.FolderPath, MainExclude_Tbl.FileExtension, " & _
"MainExclude_Tbl.FileType, MainExclude_Tbl.FileSize, " & _
"MainExclude_Tbl.FileModified, MainExclude_Tbl.FileAccessed, " & _
"MainExclude_Tbl.FileCreated, MainExclude_Tbl.FileAttributes, " & _
"MainExclude_Tbl.MyInclude INTO [" & MyKeywordMaNeTaSo & "_Tbl" & "] "
& _
"FROM MainExclude_Tbl " & _
"WHERE False;"
CurrentDb.Execute sQL6, dbFailOnError
Thank in advance
Regards
Antonio Macias
Can some one provide me with an example How to Make-Table Query to
create the Table including the required data in one-step?
Lets say I want FileName set to "Readme" , FileExtions set to
".txt" and MyInclude set to "-1"
This is my SQL:
sQL6 = "SELECT MainExclude_Tbl.ID, MainExclude_Tbl.MyKeyword, " & _
"MainExclude_Tbl.MyAppz, MainExclude_Tbl.FileName, " & _
"MainExclude_Tbl.FolderPath, MainExclude_Tbl.FileExtension, " & _
"MainExclude_Tbl.FileType, MainExclude_Tbl.FileSize, " & _
"MainExclude_Tbl.FileModified, MainExclude_Tbl.FileAccessed, " & _
"MainExclude_Tbl.FileCreated, MainExclude_Tbl.FileAttributes, " & _
"MainExclude_Tbl.MyInclude INTO [" & MyKeywordMaNeTaSo & "_Tbl" & "] "
& _
"FROM MainExclude_Tbl " & _
"WHERE False;"
CurrentDb.Execute sQL6, dbFailOnError
Thank in advance
Regards
Antonio Macias