How to Make Table

[odbcmsaccess]

i want to select data form a table using where clause.
now i want to create a table instatntly and save data for viewing and printing purpose, after printing i delete table.
since field names in new table are going to be same as in source table, can i create new table without mentioning filed names.

my code follows like this

select * from emp(source) where name=' " & kmk & " '

insert * into details(destination)

is it possible ? any other syntax please help me

[NeoPa]

Please remember to provide a meaningful Title for any threads started (POSTING GUIDELINES: Please read carefully before posting to a forum). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR

[NeoPa]

i want to select data form a table using where clause.
now i want to create a table instatntly and save data for viewing and printing purpose, after printing i delete table.
since field names in new table are going to be same as in source table, can i create new table without mentioning filed names.

my code follows like this

select * from emp(source) where name=' " & kmk & " '

insert * into details(destination)

is it possible ? any other syntax please help me

Dim strSQL As String
 
strSQL = "SELECT * " & _
         "INTO [Details] " & _
         "FROM [Emp] " & _
         "WHERE ([Name]='" & kmk & "')"
DoCmd.RunSQL strSQL