Vba sqlJobs
Vi har et projekt hvor der skal sendes signaler til en pulje connectede hardware enheder. Der kan benyttes AMQP protokol, som skal integreres med RabbitMQ og mange kommandoer skal udsendes sideløbende. Programmeringssprog er underordnet, men der skal hentes data fra SQL
I have problems installing SQL.
Hejsa. Jeg søger en programmør/web-developer der kan hjælpe med at udvikle mit online text-based browser spil. Spillet er PHP og SQL, og når spillet er færdigt skal jeg også bruge hjælp til at få det online. Jeg har en test server og et domæne. Er der nogle friske programmører/web-developer derude der kan hjælpe?, mod betaling naturligvis :) Send mig meget gerne en besked og så kan vi tale om projektet evt. i telefonen senere.
Webudviklerens opgaver og ansvarsområder: • Skrivning af effektiv kode • Oprettelse af websteder / et websted ved hjælp af stan...softwareprogrammer, vedligeholdelse af softwaredokumentation • Implementering af beredskabsplaner, hvis webstedet går ned • Vedligeholdelse og udvidelse / forbedring af hjemmesiden, når den først er bygget Webudvikler jobkvalifikationer og krav • HTML / XHTML, CSS, JavaScript • Serverarkitektur • Erfaring med server-side rammer som python, ruby, php, Java, ASP, ASP.NET • Erfaring med databasesystemer som SQL og Oracle • Grundig funktionel viden og kodningserfaring • Grundlæggende kendskab til optimering af søgemaskiner • Evne til multitask med strenge tid...
Vi trænger til at få forbedret vores uploadfacilitet på , sådan at det bliver lettere for brugerne at uploade og redigere deres profilbilleder og billeder til fotoalbum. Løsningen skal kun...lettere for brugerne at uploade og redigere deres profilbilleder og billeder til fotoalbum. Løsningen skal kunne uploade i et bestemt formater, samt gemme et par ekstra thumbs i mindre formater. Under upload skal det være muligt at beskæfre og rotere fotos. Samtidig skal billederne navngives så de passer til den enkelte bruger, og disse oplysninger skal samtidig gemmes i brugerens oplysninger i en sql-database. Løsningen skal virke til alle browsere samt til mobilenheder og de gængse browsere der anvendes dér. L&osl...
Trænger til at få forbedret vores uploadfacilitet på , sådan at det bliver lettere for brugerne at uploade deres profilbilleder og billeder til fotoalbum. Løsningen skal kunne uploade i et bestemt format, samt gemme et par ekstra thumbs i mindre formater. ...få forbedret vores uploadfacilitet på , sådan at det bliver lettere for brugerne at uploade deres profilbilleder og billeder til fotoalbum. Løsningen skal kunne uploade i et bestemt format, samt gemme et par ekstra thumbs i mindre formater. Samtidig skal billederne navngives så de passer til den enkelte bruger, og disse oplysninger skal samtidig gemmes i brugerens oplysninger i en sql-database. Løsningen skal virke til alle browsere samt til mobilenheder ...
Vi producerer indhold, design og leverer produkt i HTML. Efterfølgende implementering på CMS med inkludering af Google Analytics og tracking er der brug for hjælp til. En anden opgave indeholder hundredevis af flade html-sider, som skal gøres effektivt søgbare og pakkes i en brugervenlig responsiv løsning til afspilning på mobile devices. Vi forestiller dig du mestrer HTML5, CSS, MS SQL, CMS og i øvrigt kan addere med andre kompetencer til den bedste løsning af opgaven.
...base. Furthermore, there is the creation date / correction date 3 text fields and 2 dropdown field - and a note field. One drop down box shows the default login person (which is part of the drop down option) Searching is done on 3-4 fields individually, and results are displayed as list, which can be clicked on, as each result is displayed. The layout may be edit via CSS. The database must be a SQL database. The database must be able to handle Danish characters as “æøå” __________________________________________________________________ Database som skal afvikles på internet, med et lille antal brugere, nu 6 brugere. Login for hver af brugerne, databasen er ikke synlig uden man er logget ind. Databasen skal benyttes til oprettelse o...
Jeg skal have sorteret forskellige studerende på nogle kurser, som de hver især har rangeret. Ikke alle kurser kan have alle de studenter der søger, hvorfor dem med størst præference skal fordeles hertil. Der skal ligeledes udarbejdes en userform, da der er flere dataset at vælge imellem.
Vi har brug for hjælp til at opbygge i MS Excel rapport, som via Jetreport henter debitor / salgs data fra Microsoft Dynamics NAV 2009 R2 - SQL database.
Programiranje za SQL i Android: molim vas vaš kontakt da se čujemo na telefon xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Programiranje za SQL i Android: molim vas vaš kontakt da se čujemo na telefon xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Jeg har vedblivende arbejde relateret til vores tidligere projekt 'Application that can upload excel sheet to sql table'
I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities
...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...
I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.
I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.
I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.
• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finan...
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...
...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...
...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified techn...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...
2 excel files with VBA macro as per customer requirement
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...
One excel file with macro as per the customer requirement
...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...
I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.
... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Experience with ...
I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...
...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....
