I have an existing Microsoft Access database that I would like either upgraded or converted to a quicker and less buggy database. It is currently cumbersome and often produces errors.
The current database, which I will provide, downloads event related CSV files from one website, creates a unique Id for each row of the CSV file, and combines this file with a results file I download manually. The code for this is included in the database I will provide, as is the lookup table that matches the two files as they have different identifiers for location, e.g. Sydney = Syd.
For this upgrade project I am happy to use a program other than Access, at your recommendation, and I would like the following improvements:
- automate download of results files as well as just event files,
- combine files, and once event and results files are combined, have them readily available for future analysis
- ability to apply filters to database quickly and easily
- easy download to CSV or excel format post application of filters (or in entirety)
- additional columns, or a seperate database, that applies excel formulas to the raw database. These are generally sumifs/averageifs or one field minus another field. These formulas can be provided, and essentially compare one competitor to other competitors within that event. I would need to be able to amend the relevant excel formulas over [login to view URL] ADVISE IF YOU DON'T BELIEVE THIS IMPROVEMENT IS POSSIBLE.
I am happy with any database format that is user friendly on windows, and can continue to use Access if preferred. Note the database would be large with 400,000+ rows so not suited to excel.
I would propose to pay 25% upfront, 25% at a milestone, 25% upon completion and a further 25% 3-6months later subject to your ongoing support.
I would like the end product to include 1 year of recent data already completed.
Please ensure you comment on how you would achieve the outcome of the project in your bid.
32 pekerja bebas membida secara purata $517 untuk pekerjaan ini
Hi, I am interested in your project related to build a scraper for events data from one website and put data to a local database. Please send me a message so that we can discuss all the details. Thanks, Ramzi
Hi there, I can do database and web scraping for you. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
*** I have checked your description in detail. I have good experience on scraping/MSAccess/SQL. Do you need desktop app? I want to discuss with you about this project. thanks.
Hello sir, I have completed web/data scraping jobs many times. I am interested in your project as well. I would like to discuss details via pm. I look forward to hearing from you soon. Best Regards,