Table creation and index

**CocoriCoy** · 04-12-2012, 06:00 AM

Hi

Please find attached my document

In the Config tab, i have created a button which import in the Asset list tab a list of information from another excel document.
I've made this list clearer in three step.

Now i want to create tables (you can see some example on the Correction Document tab) with an asset id, tab name, and type which correspond to the step3 of my list of information in the asset list tab.

Thank you very much for the help

Regards

**PingPing** · 04-12-2012, 06:48 AM

You've gone a long way down the road with your worksheet/range/copy/paste code but, to be honest, it would have been better to have used ADO to get the data into a Recordset. You could then 'MoveNext' through the Recordset and, for each record, call some code that adds to the 'Correction Document' worksheet. I appreciate that this doesn't help you in the short term but, if you have to do this type of exercise again, you'll quickly see the benefits of using SQL rather than worksheet/range/copy/paste.

**CocoriCoy** · 04-12-2012, 09:47 AM

Unfortunately i'm novice in VBA and i'm discovering ADO for the first time today.

That is to say that my source of information imported in asset list tab needs to be a microsoft-access file ?

Thanks