Database vba jobs
I am looking for a freelancer who can develop a VBA procedure to download fiscal correspondences from the ADE website. Skills and Experience: - Strong proficiency in VBA programming - Experience in web scraping and data extraction - Familiarity with the ADE website and its structure - Attention to detail to ensure accurate and complete data retrieval Functionality and Features: - The freelancer should follow a detailed list of functionalities provided by me - The procedure should be able to navigate through the ADE website and download the fiscal correspondences - The downloaded data should be organized and saved in a structured format - Error handling and exception handling should be implemented to ensure smooth execution of the procedure Deadline: - The project should b...
I am looking for a macro coder who is proficient in Excel. The specific goal for the macro is to perform automated tasks. Skills and experience required: - Proficiency in Excel and VBA programming - Strong understanding of automated tasks and macros - Ability to manipulate data and perform tasks efficiently - Attention to detail and ability to analyze and report data accurately The ideal candidate will have experience in creating macros in Excel to automate tasks and manipulate data effectively. They should be able to understand the specific task requirements and develop a macro that meets the client's needs.
I am looking for an Excel VBA expert to help me with a data visualization project. I need someone with experience in creating interactive dashboards and highlighting specific data points. The ideal candidate should have a strong background in Excel VBA and be proficient in creating visually appealing and user-friendly data visualizations. This project will involve analyzing and visualizing data using Excel VBA to create interactive dashboards that highlight specific data points. If you have experience in data visualization and are skilled in Excel VBA, please submit your proposal.
READ CAREFULLY! Hello, need Excel VBA script which will transfer these data from PDF TO EXCEL: - Invoice number - Invoice date - VAT CODE - Invoice amout The invoice format may be different, there is like 10-20 different sellers invoice templates, need to recognize all of them, attaching last month invoices to check. Invoices: As one freelancer told, this is possible and i want sript work like this: "Tool will do automatically, you just need to Brower and import pdf file folder where all pdf files are saved" If you can't do it, please do not bid!
You are to design a database capable of meeting the business needs of a yacht charter company, implement your design using either SQL Server OR MySQL, test your design using Jupyter Notebooks and provide a walkthrough demonstration of your solution and underpinning code base via a recorded video screencast.
Converting HTML to Python typically involves using a library that facilitates HTML manipulation. IF YOU HAVE THE MENTIONED SKILLS KINDLY PLACE BID FOR FURTHER DISCUSSION
Looking for a team of experts to work on a decentralized web3 crypto ecosystem project. We are seeking professionals in various roles such as frontend and backend developers, API and database specialists, UI/UX designers, security experts, quality assurance testers, cryptocurrency analysts, smart contract developers, blockchain developers, and legal advisors. Project has already achieved great success in a short period of time and we intend to keep the momentum going, but to do that, we need additional hands on deck. Specific Roles to Fill: - Frontend Developer - Backend Developer - API & Database Specialist - UI/UX designer - Security expert - Quality assurance tester - Cryptocurrency analyst - Smart contract developer - Blockchain designer & developer - Legal advi...
I am looking for a developer to create a mobile app (iOS and Android) along with a web-based database management system. I have a rough idea for the design of the app and I need assistance with the design. The app should have user registration/login functionality. Skills and experience required for this project: - Cross-platform mobile app development (iOS and Android) - Web-based database management system development - User registration/login functionality implementation - User data management
I am looking for an experienced developer to provide advice on how to get my prototype PowerPoint flashcard application ready for online selling and the Microsoft Store. The application is currently in development and is a working prototype in Powerpoint with VBA automation. Specifically, I am interested in adding integration with online selling platforms to the application. This will allow me to sell the flashcard application online and reach a wider audience. The ideal candidate should have experience integrating applications with online selling platforms, particularly the Microsoft Store and other digital stores. They should be knowledgeable about the requirements and guidelines for selling applications on these platforms. Overall, I am seeking guidance on how to prepar...
I am looking for a freelancer who can automate Excel integration into Word to generate reports using VBA. Tasks to be automated: - Generating reports through integration of excel into Word. Preferred method: - VBA Data: - I will provide a description of the data that needs to be used for creating the reports.
Hello, i have alot of invoices which need to be submited to excel monthly basis, i am submiting it manually, i am thinking how to make the work easier, 30% of the Invoices is Img format, i am using Image OCR to copy value from Image and 70% is PDF format, ive tried using python script and OpenAi, but the result not very good. I have idea, but i don't know it is possible or not. Maybe excel have any shortcuts keys, which would fill the selected cell of the Column by specific key? Example: I open , copy The Faktura number, and pressing "Shortcut Key" and the selected value appears in the specific cell of the column? Then same thing with invoice date, but different key and different cell of column? hope so my idea wil be understood, i really have big headache with alot of invoi...
I have the following project, it would suit someone that has experience with Puppeteer, node.js with linux skills on a laravel framework. I'm looking for someone that can finish this feature during the current weekend, that is ready to start now and work until completion. If this is you, please bid on the project and send me a message. Here is the feature in detail.
...for an Employee Database for our Ed-Tech Company. We are looking for database in the US region for Teachers for English and Public Speaking Programs. - I want a fresh database (B2C) for our e-learning courses program and services. - Need "Teacher's" personal data, especially for recruiting purposes and our online courses. - Teacher should have excellent knowledge of English and Public Speaking subjects. - I needed data with verified Personal Email ID, First Name, Last Name and Mobile Number. - The Maximum number of Email IDs should be Yahoo, Hotmail, Gmail and Outlook client-based data. - 25 to 45 age group people. - Geo: USA - approximately 10,000 data needed. - Data should have a minimum bounce rate (not more than 2-3%). Project 2: I am looking f...
I am looking for a freelancer who can provide me with an emails database for restaurants+bars+hotels in the USA. The database should include email addresses, names, and phone numbers of the restaurant owners or managers. Specific requirements for the project include: - Database should cover all states in the USA - The information should be accurate and up-to-date - The database should be delivered within a week Ideal skills and experience for the job: - Experience in data mining ( specially google maps+yellow book+or any valid sources) and database management - Attention to detail to ensure accuracy of information - Familiarity with the restaurant+bars+hotels industry in the USA - Strong communication skills to effectively gather and organize the da...
I am looking for a freelancer who can assist me with a data entry project to build a database. The project involves entering contact details from online sources into the database. Skills and Experience: - Proficiency in data entry with a focus on accuracy and attention to detail - Experience with online sources as the primary data source - Ability to handle a large volume of entries, as there are expected to be more than 1000 entries in total. If you have the necessary skills and experience, please submit your proposal. Thank you!
Hello, i have alot of invoices which need to be submited to excel monthly basis, i am submiting it manually, i am thinking how to make the work easier, 30% of the Invoices is Img format, i am using Image OCR to copy value from Image and 70% is PDF format, i've tried using python script and OpenAi, but the result not very good. I have idea, but i don't know it is possible or not. Maybe excel have any shortcuts keys, which would fill the selected cell of the Column by specific key? Example: I open , copy The Faktura number, and pressing "Shortcut Key" and the selected value appears in the specific cell of the column? Then same thing with invoice date, but different key and different cell of column? hope so my idea wil be understood, i really have big headache with alot of...
I am looking for a freelancer who can help me with echoing my MySQL database in an array for website functionality. Database Details: - I have an existing MySQL database that needs to be echoed in an array. - The primary purpose of this task is to enhance the functionality of my website. -the project is on lines 43 to 69 Timeframe: - this is a small project thus you can take a day or two Skills and Experience: - Strong knowledge and experience in MySQL database management. - Proficiency in PHP programming language. - Familiarity with array manipulation and data echoing. - Attention to detail and ability to troubleshoot and resolve any database-related issues. If you have the required skills and experience, and are available for a small project, pleas...
...NET Visual Basic 2022 and will utilize a database in Access for the information that needs to be included. Functionality: - Search functionality for the database: Users should be able to search for books or other library items based on various criteria. - User registration and login: Users should be able to create an account, login, and have personalized features such as saving favorite items or tracking borrowed items. Design: - I am open to the freelancer's suggestions for the layout and design of the website. I do not have a specific design in mind and would appreciate the freelancer's expertise in creating an appealing and user-friendly design. Ideal Skills and Experience: - Proficiency in ASP.NET Visual Basic 2022 - Experience with database integr...
Hi, I would like to create an Excel file in VBA for betting, which takes data from a betexplorer. I need the total ranking, home, away of both teams, and the bookmakers' odds of over 1.5-2.5 and goals of the 2 teams. Salve, vorrei creare un file Excel in VBA per le scommesse, che prenda i dati da un betexplorer. Mi servono la classifica totale, casa e trasferta di entrambe le squadre, le quote dei bookmaker superiori a 1,5-2,5 e i gol delle 2 squadre.
...freelancer to create a database using either MS Access or Excel. I am open to either option, depending on which software is most suitable for my needs. Although I do not have a specific structure in mind, I have a general idea of how I want the database to be organized. I anticipate needing 1-3 tables in my database. The Database will contain approx 4-6 columns with the option of adding more if required The db should contain a filter and a search option (User friendly) !!! After creating the DB must be filled with already existing data, approx 300-400 pdf-pages, with approx 30-40lines per page. !!! Regarding the huge amount of data a Database an sql e.g. MS Access base would be a better choise Skills and Experience: - Proficiency in MS Access and...
Hey, I will be doing your work in 10$ as discussed, Thanks
a database to register instrument and follow their history
...an Access database that will help me manage client progress and billing. Functionalities needed: - Client progress tracking - Billing and invoicing System migration: - This is a new system, so no data migration is required. Reports: - I would like regular reports to be generated from the database. Ideal skills and experience: - Proficiency in Access database development - Experience in client progress tracking and billing systems - Knowledge of report generation in Access - Attention to detail and ability to meet deadlines I am using DT Max income tax software. I will be updating client progress and billing on individual clients as I process tax returns on a daily basis. I want to run a nightly extract of the data in my tax database and import i...
...create a script that will mark certain items as picked up in my database. Here are the details of the project: Specific Condition for Marking Items as Picked Up: - The items will be marked as picked up based on their status in the database. Script Requirements: - The script should be able to identify items with a specific status and update their corresponding field to indicate that they have been picked up. Additional Requirements: - There is no need for the script to mark items as not picked up based on any conditions. - The preferred programming language for the SQL script is SQL Server. Ideal Skills and Experience: - Strong proficiency in SQL Server and database management. - Experience in writing SQL scripts to update database records based on specifi...
I am looking for a freelancer who can help me with a small task involving Node.js and MongoDB. Specifically, I need assistance in setting up a MongoDB database. Skills and experience needed: - Proficiency in Node.js and MongoDB - Experience in setting up MongoDB databases - Familiarity with Requirements: - The freelancer should use for this task - Please specify any specific requirements or constraints in the project description.
I am looking for a freelancer who can help me deploy a small PHP application on the Azure cloud platform. The application size is less than 100MB. Requir...looking for a freelancer who can help me deploy a small PHP application on the Azure cloud platform. The application size is less than 100MB. Requirements: - Deploy the PHP application on a VM instance on Azure - Use MySQL database for the application - No specific requirements for the VM instance, any OS and hardware specifications will do - No need for additional services like auto-scaling or load balancing Ideal Skills and Experience: - Experience in deploying PHP applications on Azure cloud platform - Proficiency in setting up VM instances and configuring MySQL database - Knowledge of Azure cloud functions for eff...
I am looking for a skilled freelancer who can write a database query for me using the Cypher language. The project requirements are as follows: Database Type: Graph Function: Data Manipulation Complexity Level: Advanced Skills and Experience: - Proficiency in Cypher language and Graph databases - Strong understanding of data manipulation techniques and best practices - Experience with complex query writing and optimization - Knowledge of database design and schema modeling - Attention to detail and ability to deliver high-quality work within the specified timeframe If you have the necessary skills and experience in Cypher language, please submit your proposal.
I am looking for a skilled developer to create a Database Search Wordpress plugin. The plugin will primarily search a MySQL database. Search Functionality: - The plugin should include both Basic and Advanced search options to cater to different user needs. Data Size: - n/a Ideal Skills and Experience: - Proficiency in PHP and Wordpress plugin development. - Strong knowledge of MySQL database management. - Experience in implementing search functionality within Wordpress plugins. - Familiarity with optimizing database queries for efficient search performance. Please provide examples of previous plugin development work and demonstrate your understanding of database search functionality. ********************************************** Link :
I am looking for a skilled JavaScript developer who can create a form that performs calculations, stores the data in a MySQL database, and retrieves it when needed. I have created the code with the formulas already done. I need someone to modify it to make it better, do some basic CSS, php to enter the data into the database, retrieve and edit the data.
I am looking for a freelancer who can create a flow from Outlook to Excel, specifically transferring emails. The data should be formatted in a table in Excel. Furthermore, it is crucial that the data is updated in real time, meaning that any changes in Outlook should immediately reflect in Excel. Ideal Skills and...a flow from Outlook to Excel, specifically transferring emails. The data should be formatted in a table in Excel. Furthermore, it is crucial that the data is updated in real time, meaning that any changes in Outlook should immediately reflect in Excel. Ideal Skills and Experience: - Proficiency in Microsoft Outlook and Excel - Experience in creating automated data transfer flows - Knowledge of VBA scripting for Excel macros - Attention to detail to ensure accurate dat...
Develop PHP mqtt Server listener to pick up mqtt messages coming in via mosquitto and insert into db. I have mosquitto running on my windows VPS and currently receiving data. PHP mqtt server listener should be able to listen to multiple request concurrently and insert data to multiple database tables. Scope: 1. listen to incoming mqtt messages in json format. 2. Receive json messages in php and format messages as per my requirements. 3. Insert into db tables as per json message formatting
I am looking for a skilled developer to create a customer information database. The main purpose of this project is to store and manage customer purchase history. The developer would enter an NDA before proceeding to access our data. On completion of the database configuration, current information will be provided for electronic import into the database. Requirements: - Experience in Web API integration - Experience in developing secure online databases - Knowledge of database management systems and best practices - Familiarity with generating reports from the database If you have the necessary skills and experience, please reach out to me with your portfolio and estimated timeline for completing the project. Thank you!
I am looking for a freelancer to create a database for FMCG (Fast-Moving Consumer Goods) products. The ideal candidate should have experience in database management and be familiar with the FMCG industry. Specific requirements for the project include: - Inclusion of all types of FMCG products, including food and beverages, personal care products, and household products. - I am open to suggestions for the format and structure of the database. I do not have a specific format in mind, but I am looking for a user-friendly and efficient design. - The information for each product should include basic details such as the name, category, image url and price. The freelancer should have the following skills and experience: - Proficiency in database management and desi...
...a skilled database coder who has experience with MySQL. I have specific tasks in mind for this database and I require the project to be completed within a week. Skills and Experience: - Proficient in MySQL database coding - Strong understanding of database design and optimization - Experience in creating and modifying database tables, queries, and stored procedures - Knowledge of data migration and integration - Ability to troubleshoot and resolve database issues - Familiarity with security and data privacy principles in database management Tasks: - Design and implement a MySQL database based on specified requirements - Create and modify tables, queries, and stored procedures to meet project needs - Perform data migration and in...
I am looking for a PH...Azure cloud. I have no experience with Azure cloud services, so I need someone who is familiar with the platform. The ideal candidate should have experience with the following: - Deploying PHP projects in Azure cloud - Working with VM instances, cloud storage, SQL Database, and cloud functions - Using the Azure Portal to access cloud storage This project involves deploying a PHP project consisting of 10-50 files in the Azure cloud. The developer will need to set up VM instances, configure cloud storage, and integrate SQL Database and cloud functions. The preferred method for accessing cloud storage is through the Azure Portal. If you have experience with Azure cloud services and are confident in deploying PHP projects in the cloud, please reach out ...
I am looking for a developer who can create a code that allows me to open specific set of folders as tabbed on my Windows operating system. The code could be written in any language and does not require a user interface. Requirements: - Experience in programming language - Familiarity with Windows operating system - Knowledge of file handling and navigation Skills: - Proficient in Python, VBA, C#, etc. - Strong problem-solving skills - Attention to detail If you have the necessary skills and experience, please submit your proposal. Thank you.
I am looking for a freelancer who can help me deploy my small (less than 1GB) PHP project in Azure using VM instances, SQL database, cloud functions, and cloud storage. I require the latest version of PHP to be used for this project. Additionally, I need assistance in setting up the SQL database and cloud functions, including a full setup. Ideal skills and experience for this job include: - Experience deploying PHP projects in Azure using VM instances, SQL database, cloud functions, and cloud storage - Proficiency in the latest version of PHP - Knowledge of SQL database setup and configuration - Experience with cloud functions and cloud storage setup Please provide examples of similar projects you have completed in the past.
I am looking for a freelancer to create a contact database specifically for business contacts in a specific industry or demographic. The database should be organized by role within the organization and relevant distribution lists. Ideal skills and experience for this job include: - Strong understanding of database management - Proficiency in organizing data by role and distribution lists
Database for Small Business Inventory Management - Preferred Database System: Open to either SQL or NoSQL - Primary Purpose: Inventory Management - Anticipated Data Storage: Less than 1GB Skills and Experience: - Proficiency in SQL and/or NoSQL database systems - Experience in designing and implementing database solutions for inventory management - Knowledge of data storage optimization techniques for small-scale databases - Familiarity with data backup and recovery procedures - Understanding of data security measures for protecting sensitive business information Business logic description: Preparation of Shelves and Racks Labeling of Shelves and Racks: Create unique barcodes for each shelf and rack. This will allow for quick identification of the location ...
I am looking...am looking for a freelancer to develop a platform that combines training, project management, and a database using Odoo. Specific features required for this project include: Training Platform: - Interactive quizzes to engage and assess learners Project Management Component: - Reporting tools to track project progress and generate insightful reports Database Component: - Data analysis capabilities to analyze and extract valuable insights from stored data Ideal skills and experience for this job: - Proficiency in Odoo development - Experience in developing training platforms with interactive quizzes - Strong understanding of project management principles and tools - Expertise in database management and data analysis Please provide examples of relevan...
I am looking for an experienced Android app developer to modify my existing wallpapers app by creating a database mysql with admin panel instead of firebase database. Skills and Experience Needed: - Proficiency in Android app development - Ability to implement new features efficiently and effectively - Attention to detail and ability to follow specific instructions - Problem-solving skills to troubleshoot any issues that may arise during the modification process The developer will not be responsible for uploading the modified app to the Google Play Store, as I will handle that aspect myself.
I need a database of Polish companies, which will contain direct e-mails to decision-makers, and/or direct telephone numbers to these persons, together with the name of the persons to whom these e-mails or telephone numbers lead. Importantly, the companies must also have NIP numbers.(must have informations) Data on the positions of the decision-makers and turnover/revenue would also be very valuable. A little less priority would be given to data on employment, role-based emails or company phones. Data that would be good to include, although of the lowest priority, would be company addresses, the industries in which they operate, PKD codes, names, etc. Payment for the database will depend on the coverage with the above requirements and the number of companies (the more t...
Project Title: MySql database recovery UPDATE: I've uploaded some sample files with both IBN and FRM files so you can have a look. And separately the entire data directory. Project Description: I need help to recover my MySql database ASAP. My hoster's server crashed and I managed to recover only the data directory with all the ibn and frm files. Nothing else. No log files at all. It might be useful to know that I tried to recover the DB using the mysqlfrm utility which throw out a character utf8 related error. I also tried to recover using Stellar Repair for MYSQL but without the log files there's no way the app can restore the DB. Current State of the Database: - The database has crashed and needs to be restored. Data Backup: - I have the ...
I am looking for a freelancer who can create a user form in Excel for me. The form that I need is a data entry form. I have a specific design in mind for the form, so the ideal candidate should be able to replicate that design accurately. The user form should have between 6 to 10 fields for data entry. Skills and experience needed for this project include: - Proficiency in Excel and VBA - Experience in creating user forms - Attention to detail to accurately replicate the design - Ability to create a user-friendly and intuitive form for data entry.
...with my MS ACCESS Database project. The purpose of the database is to store and manage customer data, track inventory and sales, and analyze financial data. Specific requirements for the database include: - User-friendly interface for easy data entry and retrieval - Ability to generate custom reports and queries - Integration with other applications, such as Excel or Outlook I anticipate needing less than 5 tables in the database to meet my requirements. Ideal skills and experience for this project include: - Proficiency in MS ACCESS and database design - Knowledge of SQL and query optimization - Strong attention to detail and ability to meet deadlines If you have any examples or suggestions for additional features that would enhance the functiona...
Add data to firebase database using an endpoint The data to be added will come from a webhook. That means, we need an endpoint to receive the JSON in post form.
