Get filtered/grouped external data into MS Access table

[Richard1980]

Hello everyone,
I am struggling with this task.
I have an Excel file with a name range "DBIAS" which identifies all database data.
Then I have an Access file with a form to import that database (better, that named range) into an Access table. While importing, I have to filter some records or grouping by some field.
I cannot run correctly a VBA code to get data (filtered and/or grouped) from that name range and save those records to an existing or a brand new table.
I need some assistance from you, VBA experts.
I could get those data as DAO.recordset and printed out with "Debug.print" on immediate window, but I cannot complete the final step: writing those records to a table.
Many thanks!
Bye. Riccardo.

 

[Uncle Gizmo]

Move the records to a temp table in MS Access and then do your filtering / grouping.

 

[Richard1980]

Hello, thanks. Good but not the best option (or the option I am searching for). The source database has thousand of records and I don't like create a temp table. Anyway, thanks for your suggestion. Bye

 

[JHB]

...
I could get those data as DAO.recordset and printed out with "Debug.print" on immediate window, but I cannot complete the final step: writing those records to a table.
...

And why couldn't you do that, (show your code)?
Why do you don't like create a temp table, (Uncle Gizmo solution is much faster as looping through as recordset and writing to a table)?