Jan 9, 2006 #1 F fguihen Well-known member Joined Nov 10, 2003 Messages 248 Location Eire i have run a query in access which returns a lot of rows. what is the sql syntax to save the returned data in a new table?
i have run a query in access which returns a lot of rows. what is the sql syntax to save the returned data in a new table?
Jan 9, 2006 #2 HJB417 Well-known member Joined Mar 5, 2003 Messages 609 Location Lowell, MA http://msdn2.microsoft.com/en-us/library/ms190750.aspx should work in access jet.