Completed

VBA script to batch import xml files in MS access

I have a folder with 6000+ xml files, all structured in the same way. I need to import them into MS access in order to have a more useful database.

I manually imported a couple of them, however I would now like to import the rest in an automatic fashion. The xml files need to be appended to the only table in the access file. The xml files are named in sequence with the following structure [login to view URL] where the suffix MGPPrezzi obviously does not change. The files start from 20050101 and end 20220624: some files are attached so that you can test the script. I am not sure if there are missing files, should the file be missing, the script should write down the filename/date in a (single) txt file or in a separate table, and fill in the 24 rows (hours) for that day with an empty cell. Not a N/A, not a 0 (that would mess up the formulas I will need to use later on in the process).

Once complete, the script should write in the txt the outcome of the import process: something like x files were successfully processed, y files where missing.

I should be able to run this script as a macro from within MS access with the ability to change the dates of "from" and "to" or "all files in the folder xyz". If a date is already present in the access database, an option should be given before starting (not at each occurrence) to either overwrite or to skip that date/data.

Skills: Microsoft Access, Visual Basic for Apps, Data Entry, Data Processing

About the Client:
( 3 reviews ) London, United Kingdom

Project ID: #33978503

Awarded to:

(99 Reviews)
5.5

7 freelancers are bidding on average £48 for this job

(66 Reviews)
6.4
(54 Reviews)
5.7
kevivu

Hi There, I have reviewed your requirement and I can definitely start immediately. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my free More

£100 GBP in 3 days
(57 Reviews)
5.8
joicyarockiaraj

Ready to start ASAP. I have more than 5 years experience in Excel VBA and data entry. I can make you the very best work completion with 100% accuracy in said time. Am fast and reliable who will complete in your budget.

£15 GBP in 2 days
(18 Reviews)
4.3
(5 Reviews)
2.5
malikrashidali16

Hello sir , i read your project requirement , i have 5 year experience in MS access and i have done another vba import conversion . Further detail inbox me . Looking forward. Malik_rashidali

£10 GBP in 2 days
(0 Reviews)
0.0