>Hi,
>
>I need to copy a table in one access database to another. Is there a simple way to do it, or do I need to create a new table with all the fields, and spin the source table row by row and populate the new table.
Check the syntax of «Insert Into». You can do this using a single SQL query.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com