Make New Table Query Including Data One Step

  • Thread starter Thread starter rebelscum0000
  • Start date Start date
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
 
Would you not just put your criteria into the WHERE clause? Like

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 MainExclude_Tbl.FileName= 'Readme' AND ... ;"
 
Back
Top