I am trying to insert all the fields from a query to a table. I use the following statement from vba:
Expand|Select|Wrap|Line Numbers
- INSERT INTO [myTBL] select myquery.* from [myquery];
The number of records in [myquery] is 300 but when [mytbl] is loaded it comes up with more records. Any idea why this might be happenning??
thanks a lot..