Search results

mate, not to worry. the solution I have now will last me for a long while. Greatly appreciate if you can point me to some good books I can start learning access vba and xml stuff. having these knowledge and capability will be useful in the future. thanks a million

It works!!! Hi all, Thank you all for your advice and sample codes, especially ajetrumpet. His code works and I am not sure ajetrumpet did it delibrately or not.:p I encountered a runtime error for object not set and made some changes to his code. I added near the beginning of the function...

Mate, you are absolutely correct that it seems a lot of work. Like I said, I an new to VBA and absolutely a noob to XML. It is too much an ask for my current capability. The XML files are all in 1 main folder with many sub-folders. Conceptually, I know that I will need to trawl through all...

Hi boblarson, The source files are all XML and external. With little knowledge on XML and with insufficient time, I found an utility that allows me to import the XML files into Access. Sort of a quick and dirty solution that will last me for 6 months at least. There are many imported tables...

Many thanks Adam. Your sample code is exactly what I need to get a head start. Will let you know how I go.

Thank you guys for your feedback. Let me be more specific. This database has varying number of tables from 50 - 1500 each week with the same table name except the last few digits. Each table has 4 fields and only contain 1 record each. I would like to have a separate database to loop through...

Hi all, I am new to VBA and hope you can assist. I have a database with, 1. Around 50 - 1000 tables of the same data structure. 2. Each week the number of tables differ. 3. All the tables start with CustAcctXXX where XXX is the number eg CustAcct123, CustAcct456 and so on... I need to...