Đã hoàn thành

new VBA script to batch import xml files in MS access

I have a script written by someone else that imports xml files into an access table ("Prezzi"). It did the job just fine, with a couple of issues mentioned below.

I now have another 3 sets of a total of 20,000+ xml files. Like before, the structure of the xml and therefore table doesn’t change much over time, but from time to time the issuer of xml files has added some fields and dropped others, so we need to take it in steps in the sense that we need to be patient if not all fields are present and add them.

I need to add this next lots of xml files to the corresponding tables in the access file:

1) “ServiziDispacciamento”

2) MBPAltriServizi

3) MBPRiservaSecondaria

The files are in chronological order and the follow the structure:

- [login to view URL]

- [login to view URL]

- [login to view URL]

The xml files need to be appended to the corresponding tables in the access file. The xml files are named in sequence with the following structure [login to view URL] where the suffix nameofthetable obviously does not change. 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 were 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.

I would like the xml files to be stored in separate folders so that I can keep a track of what is being do

Compared to the script in the access file attached that you can freely leverage, I would need to you to make changes to the code in the access file attached so that the data are easier to use/query afterwards:

- Numbers should be imported in fields that are classified as numbers with “double” length, rather than text strings

- Numbers currently contain a comma as a decimal separator. This should be converted to be a dot (“.”) in the table

The access file contains the empty tables ready for the import of xml files above. Each of the fields are classified as long text, but they all (except for "data" and "ora") need to be converted into a number with "double" length.

This should be everything, please ask away if you have any questions.

I will consider these main elements in assessing your proposals:

- evidence of experience at previous similar jobs

- time to deliver

- cost

Kĩ năng: Microsoft Access, SQL, Xử lí dữ liệu, Visual Basic

Về khách hàng:
( 4 nhận xét ) London, United Kingdom

ID dự án: #34055256

Được trao cho:


Hello! I'm a Databases Developer, Access, Excel and VBA expert more than ten years. I have completed many complex projects in my practice and I am ready to carry out your project in the reasonable price and in the shor Thêm

£135 GBP trong 3 ngày
(261 Đánh Giá)

13 freelancer chào giá trung bình£150 cho công việc này

(206 Nhận xét)
(84 Nhận xét)
(80 Nhận xét)
(70 Nhận xét)

Hello, ## I've previously worked on the exact similar project for Other employer. ## Would you check my feedbacks? https://www.freelancer.com/u/carina0530 I'm fullstack expert, with over 10 years experience dealing Thêm

£145 GBP trong 7 ngày
(5 Nhận xét)
(23 Nhận xét)

I have a lot of work with the VBA script I understood your requirements but I have a few doubts, text me so I can clear all my doubts right away

£350 GBP trong 5 ngày
(5 Nhận xét)

I have created and processed XML files in VBA and created applications in MS Access and have 5 years experience in MS Access for international client and in open source for eCommerce domain. Time would be 15-20 Days Thêm

£20 GBP trong 7 ngày
(3 Nhận xét)

I specialize in Html, Node, Laravel, Shopify, Python, JAVA, PHP, and react. I can use the following web languages Web Languages HTML, HTML5, XHTML, Bootstrap, CSS, CSS3, JavaScript and jQuery. My other skills include Thêm

£135 GBP trong 7 ngày
(1 Nhận xét)

Hello, I have experience in Data Science, data analysis, data processing, visualization and Data Mining I also have the ability to use R programming language, to perform various data analysis processes/activities, e.g. Thêm

£100 GBP trong 40 ngày
(0 Nhận xét)

Hello. How are you doing? I have very interested to your proposal. I can write VBA script to batch import xml files to MS Access. I will guarantee the quality of the code and will deliver you the result asap. Looking f Thêm

£120 GBP trong 5 ngày
(0 Nhận xét)

Thank you for your reading of my proposal sentence. I can say you Excel, VBA, Visual Basic is the senior skill I had a deal with many data changes, manage projects. business logic, and math formula, I am good at them, Thêm

£135 GBP trong 7 ngày
(0 Nhận xét)