I would like to pick up few rows from existing table in Access 2003 and put them into new table via VBA.

Any solution
Thank you in advance!

Re: Creating new table in Access 2003



Suggest that you use the Docmd.RunSQL command the below example takes data for one day from on table and puts it in another, Warnings are turned off so that you do not have to press OK to overwrite the table if it already exists.

Dim strSQL As String

strSQL = "SELECT Production.* INTO [tbl Temp] " & _
"FROM Production " & _
"WHERE (((Production.Date)=#5/15/2007#));"
DoCmd.SetWarnings False
DoCmd.RunSQL (strSQL)
DoCmd.SetWarnings True

Re: Creating new table in Access 2003


Dear ADG, Hi,

You made a great help. Thank you indeed. In case of any questions, I will come back to you. (New Post!)