Get records from Access table
- by chianta
On Access 2010 I need to use VBA to get the records in a table, process them and put them in a new table. Could you tell me how can I do?
Is there a way similar to C # to put everything into a datatable the result of a query?
I found an example on how to get the data. http://pastebin.com/bCtg20jp
But it always fails on the first statement "ADODB.Recordset". I went to see the included libraries and library that uses ADODB is already included "Microsoft Access 14.0 Object Library".
Thanks