Entry

how to use sql command in access to create a table which have the same structure of an existing tabl

Jul 19th, 2007 06:00
andrew at, ck ng,

We have table "xxx" with some fields and data in access DB. Go to 
"queries" and create query for example: 
"SELECT * INTO yyy FROM xxx;". After execution one, we have table "yyy" 
as full clone for table "xxx".