Create table from a loop of file in dir

[sal21]

I already have an active connection with ADO which is called CON.

My database (Access) contains a table, TEMPLATE with fields already encoded and all without data.

Now I loop some files in a dir and pull out during the loop for each file its name which I call FILENAME.

How can I with a function, create nn tables with only structure and rename them with FILENAME?

[HansV]

Why do you want to create a table for each file? It would be better to use a single table with an extra FileName field. That is much more efficient than separate tables.

[sal21]

Why do you want to create a table for each file? It would be better to use a single table with an extra FileName field. That is much more efficient than separate tables.

Bro...
But really my prob Is tath....
Based The last post about to import value from JSON file to the and of import i have approx 13.000.xxx of Row.!!!!
Idea....
Split the big file in a Little piece and save record i a separate table.
If you have another idea....