Insert data from excel vba to sql jobs

...need a professional to scrape the stock information from the first 6 stocks on the first of each month starting from 1/1/2014 till the current date on the Chartmill website. You will need to register for a free account. The filter for 2/5/2024 is ,ind_22,date_2024-05-02&v=1&s=p6m. Key Requirements: - Extract the stock code and all fields that are available on the website for the first 6 stocks. - Ensure data is accurate and up to date. Timeframe: I'm looking to have this completed as soon as possible. Ideal Skills and Experience: - Comprehensive experience in web scraping, particularly from financial websites. - Familiarity with stock market data and terminology. - Ability to deliver a high level o...

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of ...

I'm looking for an experienced C programmer to create an IEC-104 slave application from a Modbus TCP/IP implementation done in C for Linux. This application will run on Debian and will be primarily used for monitoring and logging purposes. Key Deliverables: - Develop IEC-104 slave application - Implement monitoring and logging functionalities - Ensure seamless integration with existing Modbus TCP/IP implementation Ideal Skills and Experience: - Proficiency in C programming - Experience with Linux, particularly Debian - Prior exposure to Modbus TCP/IP and IEC-104 protocols - Strong understanding of monitoring and logging systems - Ability to deliver clean, efficient and well-documented code If you have prior experience in similar projects or have a stro...

I need a Python developer who can create a script to scrape news in JSON format from moneycontrol at a specified interval and store it in a database. Key Requirements: - Develop a Python script to scrape news in JSON from moneycontrol - Automate the scraping process at a specified frequency - Ensure the scraped news is stored in a database Ideal Skills and Experience: - Proficiency in Python - Experience with web scraping using BeautifulSoup or Scrapy - Knowledge of working with JSON data - Familiarity with databases and data storage - Previous experience in similar projects would be a plus Please note: The project does not have specific requirements for news categories or keywords at the moment. The focus is on extracting news in JSON format an...

We're in search of a highly versatile .NET developer for our undisclosed project. While we haven't stated specific skills or project type, candidates should have: - Broad knowledge in .NET and its most popular programming languages (i.e., C# programming, ASP.NET development, and SQL database) - Experience in various .NET projects (i.e., web and desktop applications, as well as enhancement of existing .NET applications) - Proficiency in Windows, Linux, and Mac development platforms Your flexibility and adaptability are our key considerations as project specifics will be discussed upon engagement.

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previ...

I have a set of handwritten notes with relevant numeric data that I need entering into an online database. The task involves transcribing the numerical information with a high degree of accuracy. Key Requirements: - Enter numeric data from handwritten notes into an online database - Ensure high accuracy in data entry - Abide by project deadlines - Maintain confidentiality of data Skills Required: - Proficiency in data entry - Attention to detail - Experience with online databases - Fast and efficient work ethic - Ability to maintain data confidentiality

I'm seeking a graphic designer to help craft a bold and vibrant label for my Liquid vitamin product. To take existing artwork and examples of art direction and create labels using requested art direction and existing logos. Key Responsibilities: - Create a distinct, DELICIOUS looking label - Reflect our unique brand and identity (logo) Ideal Skills: - Proficiency in graphic design software - Experience with food and beverage industry branding - Strong sense of color, style and typography - Ability to design vibrant, attention-catching labels

I'm currently seeking a WooCommerce expert to assist with product management on my online store. The job involves: - Importing products: I have a 2x CSV file with new products that need to be added into my WooCommerce store and set up wpallimport. I have wpallimport licence. - Updating products: Some existing products on the store need to have their details revised to match the new information in the CSV file. The ideal freelancer must have experience with WooCommerce, and should have previously handled similar tasks. I need someone who can complete the job efficiently and accurately. Your familiarity with CSV format and how it can be used to update and add products in WooCommerce is crucial.

I've built a web application using .NET for the backend, Angular for the user interface, and SQL database. Now, I'm looking for someone to help me publish this website on the cloud and make it live. It's a small web app designed for a local business, with a limited number of users (around 15-20). Because of this, I'm aiming to keep costs as low as possible. I'm open to suggestions on which cloud platform would be best suited for this project. If you're interested in taking on this task and helping me get my website up and running, please reach out. Thank you!

...MySQL skills to help me write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore...

I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent c...

**Project Scope** Seeking skilled Data Analyst specializing in PUBG Mobile to elevate our team's performance using data insights. Project goals: * Performance Baseline: Deep understanding of our team's key metrics (individual players & team stats). * Competitive Benchmarking: Analyze opponents to uncover strengths, weaknesses, strategic tendencies. * Optimal Rotation Analysis: Decipher winning map rotation patterns from videos. Find areas we can improve. * Data-Driven Recommendations: Provide clear report on insights and suggest changes to team composition, drop spots, in-game decisions. **Project Deliverables** * Structured dataset in Google BigQuery with our team's gameplay stats + relevant opponent data. * ...

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are succe...

...candidate should have experience in these areas and be comfortable starting a project from scratch. I will give you a dump from my MySQL table. From which I need an interactive HTML interface, based on Perl, HTML, HTMX to this table. I need to be able to search, add, edit and delete entries as well as combine two entries into one, all via one HTML::Template file with a single perl script as interface to the MySQL table. I do want an active submit button for all changes, as well as a single interactive upload button for each field of the MySQL table. also each field needs to be validated via a given specification. All code needs to be well documented and commented. Perl based database interaction needs be "SQL Inj...

...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid exper...

...developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experience...

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear an...

I'm looking to have a decal designed for my boat, taking inspiration from a vintage photograph. - Size: The decal should be 11" tall by 32" long. - Design: The decal should be based on and recreated from an old picture, with some creative interpretation. Feel free to suggest any improvements to make the design more striking. Your creativity and ability to work with vintage inspiration will be crucial for the success of this project.

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be availa...

I want all funeral directorss email addresses scraped from All send on a spreadsheet with Names, phone number, city and email address Price for all contacts from the site PLEASE PROVIDE PRICE TO COMPLETE THE JOB. DO NOT MESSAGE FOR A CHAT DO NOT BID A PRICE THEN ASK FOR A HIGHER PRICE Feedback will be left according to quality of work.

I need an in-depth and comprehensible 2000-word report on relational databases. This should include: - A focus on normalization and handling of relational database constraints. - An E-R diagram and an SQL query. The project description doesn't specify requirements for these, so use your expert judgment to determine what is necessary. - The report should also be accompanied by a 15-slide PPT presentation summarizing the report's highlights. Ideal Skills & Experience: • In-depth knowledge of DBMS • Expert understanding of relational databases • Proficiency in E-R diagrams and SQL query • Excellent report writing skills • Experience in creating engaging PPT presentations.

I'm seeking a professional who can help me craft a comprehensive 2000 word report on Database Management Systems (DBMS). The report needs to cover the key concepts of DBMS, including E-R Diagrams, Normalization (3NF), and crucial SQL queries. The report should be well-researched, well-structured, and free of any plagiarism. I also need a PowerPoint presentation to be created, consisting of 15 slides based on the content of the report.

I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.

...Gallen we are looking for a solution to convert PDF documents into HTML. We are looking for someone to convert a scientific journal and books, containing approximately 16,000 pages, from PDF to HTML format. The project consists of 20 books and the scientific journal over 20 years. The goal is to make the content searchable, enhance its readability, and store it as HTML in a knowledge database. The PDF contains footnotes that should also appear as superscript in the text in the HTML. The content of the footnotes should appear at the end of the HTML, preferably as a link to the referenced footnote in the text. Please also note that umlauts should be displayed correctly in the HTML. Your responsibilities will include: - Converting the entire jo...

I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.

I'm in need of a skilled article writer to work on my game project. The articles will vary in content and tone, covering game reviews, tutorials, and news updates.

...IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experi...

I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10...

...I have a detailed sketch of the logo on paper. Your job is to convert it into a digital format. - The logo is a combination of a symbol and text, so you should have experience working with both elements in logos. - The logo should be completed within the next 2 days, so I need someone who can work quickly without sacrificing quality. File Formats and Color Scheme: - The final logo should be delivered in PNG and PDF formats. - The color scheme for the logo should include nude for the hand, gold for the card, and a mix of gray, black, and blue for the text. Ideal Skills and Experience: - Proficiency in graphic design software and experience in creating combination logos. - A strong sense for color coordination and ability to translate a hand-drawn concept into a digi...

I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.

We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.

I need a skilled professional to copy an order form from an existing website. The task involves: - Replicating the design and layout of the existing form - Ensuring that all are copied accurately - Making sure the form is functioning as it should - Identifying the backend technology used in the original form (if possible) Here is the site: Use google translate if you not can read it We need exact the same design, functions, etc. Exactly same technology and functions. If can't give us that, we have no interest and you waste our time and your own. THANKS

I'm currently looking for a...individual or team proficient in picking and packing small electronic devices, such as lab pipettes from Lincoln, NE 68502 and ship it to Illinois 60010. The items are from university auction, you need to schedule the pickup during work hours, retrieve the items, packing up, and ship USPS. The final package size would be a medium flat-rate USPS Priority Mail box, total weight less than 2lbs. This is an one-time project. The ideal candidate/hire: - Should have some prior experience in the electronics field or with similar work. - Must exhibit careful handling to prevent any possible damage. - Ability to work with a high level of accuracy and speed. This job entails meticulousness and a keen attention to ...

...need of a highly skilled data entry operator to assist with my Tally entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs t...

We need to create a layer over googlemaps for our website.* We have all necessary icons and you just need to insert that layer. The task is. Provide us with an layer for googlemaps for our website and insert 15 icons. (we have the icons ready) You bid for the entire project until completion which should be an easy job.

I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years

I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.

...specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily invento...

Generate Exe from Python Source Code and How to Backup Files from Pythonanywhere. I need someone who can just put the Icon on the Code of Python and generate the EXE from Python Code and also how to backup all files from PythonAnywhere.

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

I'm seeking a skilled freelancer to set up my website on WordPress from a provided Figma file. I have already purchased the domain name. The project does not currently encompass hosting setup, so hosting capabilities would be a plus. While I have not specified any particular WordPress plugin requirement yet, the chosen freelancer should be familiar with a range of plugins and ready to recommend if necessary. Key Skills Required: • Expertise in WordPress • Figma proficiency • Familiarity with various WordPress plugins • Possessing Hosting setup knowledge is a bonus.

...Integration of AI technology to extract data and analyze shopping cart contents. (Text extraction) - Implementation of APIs to collect and compare product data in real-time. - Creation of algorithms to identify and recommend similar products. (Might not be needed) - Development of a scalable backend to support real-time data tools and user analytics. Requested Technical Skills: - Experience creating sustainable Data modells - Experience in browser-extension development with JavaScript, HTML, CSS, and modern frameworks (React, Angular, Vue.js). - Proficiency in backend programming, particularly with Node.js or Python. - Strong understanding of RESTful API design and development. - Experience working with cloud services (AWS, Azu...

...startup is seeking an experienced freelancer to join our sales team and drive growth for our mock interview services. As an independent contractor, you'll have the flexibility to work remotely and set your own schedule while earning competitive commissions for each successful sale. **Key Responsibilities:** - Utilize your expertise in sales to identify and target college graduates, job seekers, and professionals across industries such as IT, sales and marketing, finance, and accounting. - Craft persuasive pitches to showcase the value of our 30-minute mock interview sessions in preparing candidates for specific job roles. - Implement strategic sales tactics to exceed targets and maximize earnings potential. - Build and maintain relationships wit...

I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities th...

I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to...

I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task for 1 Hour, If you Completed ON TIME means we will give you the Project. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on hourly basis

I'm seeking proficient data entry specialists for the purpose of converting alphanumeric data from physical documents into digital format. Key Responsibilities: - Accurately enter alphanumeric data from physical documents - Cross-checking entries for accuracy - Maintain the confidentiality and integrity of the data Ideal Skills and Experience: - Proven experience in data entry - Fast and accurate typing skills - Proficient in English - Ability to decipher handwritten data - Detail-oriented with a focus on data accuracy - Experience in working with physical documents is beneficial. Prioritize those who maintain a professional attitude towards time efficiency and document confidentiality.

Looking for an experienced PHP developer who can guide me to migrate a PHP Website from 5 to 8.1