Extract database search results in a csv file into Excel
- or -
Post a project like this3519
€110(approx. $118)
- Posted:
- Proposals: 15
- Remote
- #546393
- Completed
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
I need help automating data extraction from a proprietary database. This means that the database is behind a codewall and i am unable to share my codes with the developer. This was not clear from my first version of this job description. Please take this constraint into account when bidding. Sorry for the inconvenience to those who have already bid.
General information for the business: Need to automate extracting information from a press database behind a codewall.
Description of program: Take data from my Excel spreadsheet (the data represents the search terms)
Enter data into proprietary database accessed using Internet Explorer
Click on enter
Database returns lots of search results, including a csv file showing the search results over time. This file is what I want.
Get csv file results. Open in Excel. Copy data and put it into my spreadsheet
Put csv file with name into a specific folder.
Close up csv file and start the process again
Description of requirements/functionality: This should I believe be coded using VBA as the database is in Internet Explorer and the file is under Excel.
OS requirements: Windows
General information for the business: Need to automate extracting information from a press database behind a codewall.
Description of program: Take data from my Excel spreadsheet (the data represents the search terms)
Enter data into proprietary database accessed using Internet Explorer
Click on enter
Database returns lots of search results, including a csv file showing the search results over time. This file is what I want.
Get csv file results. Open in Excel. Copy data and put it into my spreadsheet
Put csv file with name into a specific folder.
Close up csv file and start the process again
Description of requirements/functionality: This should I believe be coded using VBA as the database is in Internet Explorer and the file is under Excel.
OS requirements: Windows
Andrew Z.
100% (14)Projects Completed
18
Freelancers worked with
19
Projects awarded
78%
Last project
17 Jun 2020
France
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies