Import data database via odbc excel using vbaJobs
...play a crucial part in boosting our sales and expanding our customer base. If you have relentless drive, passion for sales and a proven track record, I want to hear from you. Key Qualifications: - Proficient in cold calling - Exceptional negotiation skills - Experience with e-mail marketing - Beforehand Consumer Products industry experience Your role will involve connect with potential clients via phone and email, showcasing our product range and closing deals with potential clients. It's crucial that you're comfortable interacting and building relationships with clients daily. We are selling e-scooter and mobility scooters. This is our homepage: We are selling in Germany and we have a strong position on the german e-scooter and e-mobility market. We are
import all the data from a json to custom compis all json data must be imported
I need an experienced Wordpress developer who can customize themes and utilize the design builder to give my website a modern and professional look. The site needs to be responsive for mobile devices as well to cater to our members. Key Responsibilities: - Theme customization according to prerequisites - Design Builder implementation Desired Skills & Experience: - Proven ...Ability to design responsive and mobile-friendly websites - Knowledgeable in understanding and aligning with target audience (members) requirements. The desired outcome of these services is not just a visually pleasing interface but also one that resonates with our intended audience. Ideally, my site after completion will have a sleek, professional, modern look, and easily accessible to our members via m...
As the owner of a WordPress site, I'm currently facing several separate issues that need resolving. Here's what's happening: - Cron j...facing errors with cURL 7. - The REST API is malfunctioning. I'm seeking a professional WordPress developer who can tackle these problems. Given these are separate issues, a deep understanding of all three areas (cron jobs, cURL 7, and REST API) is crucial. ****** FIX THE ISSUE USING ANYDESK IS MANDATORY ******* By the end of this project, I expect: - Cron jobs working to schedule flawlessly. - cURL 7 operating without any errors. - The REST API functioning correctly. The task requires working via AnyDesk Remote Desktop, so experience with remote troubleshooting is necessary. Please only apply if you're ...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in condition...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.
I'm urgently seeking a skilled developer to set up a Helios 2 Lidar camera for detecting human figures and calculating distances up to 10 meters. Key Requirements: - Proficiency in setting up and customizing Helios 2 Lidar camera - Mastery of object detection, specifically human figures. - Capable of implementing short-range distance calculation (up to 10 meters) The project demands someone who has a strong understanding of Lider camera configurations, and advanced skills in object detection and distance measurement methodologies. Your competence in creating systems to accurately detect human figures and calculate short-range distances will be the driving forces behind the success of this project.
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...
...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...
...manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requir...
For my website, I'm seeking a skilled Shopify developer who can work with me regularly on an hourly basis via Slack. The key tasks you'd handle include: - Minor corrections - Ensuring mobile responsiveness - Adjusting product pages - Customizing the theme. I mainly cater to general consumers. Therefore, finding a way to make the site welcoming and easily navigable for this vast audience is paramount. An understanding of consumer behavior online and expertise in user-friendly design would enhance your efficiency in fulfilling the tasks. The ideal candidate should have proven Shopify development experience, possess excellent troubleshooting abilities, and have a strong understanding of responsive design. Also important is the ability to effectively communicate and coll...
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in...
follow these steps: 1 Data Collection: Copy relevant text from writer work such as articles, essay or book into a document or text editor. 2 Cleanings and Preprocessing: Remove any unnecessary text such as header footers or non-essential information. You might also need to correct any formatting issues or errors introduce during copy 3 Text Analysis: Analyze the copied text for various metric such as word frequency readability score sentiment analysis or topic modeling. This can provide insight into the writing style tone and themes present in the text. 4 Statistical Analysis: Calculate statistical metrics such as word count average sentence length or vocabulary richness to gain deeper insights into the writing style and complexity 5 Visualization: Create visualizations...
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a syste...
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...Google Cloud Platform (GCP) or Amazon Web Services (AWS). 2. Administrative Requirements: - Secure admin portal accessible via the website and potentially a mobile interface, for content and user management. - Functionality to handle various user roles, manage content moderation settings, and enforce domain verification protocols for enhanced security. 3. Content Creator Specifications: - User registration with OAuth integration options (Google, Facebook) or traditional email sign-up. - Compulsory email verification alongside professional accreditation checks for enhanced credibility. - Key features for content creators include: - Integration with external APIs for data management and content enhancement. - Configurable upload limits for videos an...
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
I need a Zapier expert to create a flow that will automate the d...identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and dealing with CSV files. The timeline is asap, and the budget for this is £50, payable once Zap is live, deployed, passed our testing, and any troubleshooting is completed by...
I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
...and I have some specific goals in mind. Key Responsibilities: - Providing initial Zoho CRM training and guidance for a beginner. - Assisting with setting up and customizing the platform to align with my business needs. - Guiding and teaching me how to improve my sales process using the CRM. - Helping automate certain key business workflows through Zoho CRM. - Coaching on how to effectively manage customer relationships through the platform. The ideal candidate for this project would: - Have extensive experience using Zoho CRM. - Be an excellent and patient teacher, capable of explaining complex concepts in an easily understandable manner. - Be able to provide practical examples and use cases that are tailored to my specific business needs. - Ideally have a background in ...
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
I'm looking to have a tool developed that can analyze biological microscopy images, specifically with features such as color segmentation, edge detection, and cell counting. The tool should also support universal data import and corrections of alignment and image rotation. Ideal candidates for this project should have: - Strong proficiency in Python and Java - Previous experience with image analysis and microscopy imaging - Fiji, Maven, Eclipse preferred - Bio-formats - Would be great if you have experience in setting up a Fiji plugin (post your work)
...affecting the sale of water heaters This project requires hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantag...
I'm in need of a skilled professional who can conduct cold calling to generate leads for my service. The ideal candidate should have a background in lead generation and cold cal...with experience in B2C markets. Key Requirements: - Experience in cold calling, with a strong track record in lead generation - Ability to effectively communicate the benefits of a service to consumers - Understanding of B2C markets and consumer behavior - Strong sales and persuasion skills - Ability to work efficiently and independently Your main tasks will include reaching out to consumers via telephone, introducing and promoting the service effectively, and capturing their interest to generate quality leads. Your success in this role will be measured by the number and quality of leads you'...
I need a WordPress expert to help me import posts from a JSON file to my website. I need to import posts from a JSON file to my WordPress site, without any media files, just the text content. This is a one-time job and I want the imported content to look exactly like the original. Key requirements: - Expertise in WordPress - Proficiency in handling JSON file imports - Attention to detail to ensure no data loss Please ensure that you have prior experience in handling similar projects.
I'm in need of a custom Python parser using the pylatexenc library. It should mainly feature: - Special Feature Parsing: This parser must be able to parse through figures, tables, and equations specifically, while remaining in original LaTeX format. - Format Conversion: convert to simple text The ideal candidate for this project will have proven Python skills, familiarity with the pylatexenc library, and knowledge of LaTeX. They should also have experience with custom parser creation, and be familiar with converting LaTeX into other formats. Note: extensive testing on sample latex projects needs to be conducted to make sure its generalizability.
Create a JS-based WYSIWYG Editor integrated into WordPress Website run a WordPress-based website that is a UGC (User Generated Content) platform. I want users to be able to format their blog posts before publishing. WordPress core and TinyMCE are too heavy and too expensive respectively. I want to implement the same functionality of TinyMCE 7 (free version) via custom code in my site. Requirements of the WYSIWYG Editor: - Support for bold, italics, underline, link insert, link remove, align, highlight, font size, font-family, tables, and more. - Support to format HTML tags automatically. Auto add/remove tags to make programmatic sense. Auto format text pasted from WordPress - Proper functions so that I can programmatically insert content in the editor. - Quickbar to show releva...
Necesitaria el código para integrar en mi web de un formulario que los clientes puedan rellenar y me vuelque los datos a un excel de google, o a varios pdfs
As the client for this project, I urgently require an expert in VBA.
I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type...
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save...
I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.
I'm seeking experienc...working but to also significantly streamline our workflow, foster improved collaboration among team members and give a substantial boost to our overall productivity. Ideal applicants for this task would possess: - Extensive experience with Clickup in a professional setting - Proficiency in conducting online training via Zoom - Ability to explain complex processes in simple, easy-to-understand terms - Proven track record in improving workflow, collaboration, and productivity using Clickup. Please provide evidence of similar projects you've undertaken in the past, and explain how you'll tailor the training to meet our specific needs. Looking forward to working with a dedicated professional who can help take our team interactions and...
I am seeking a skilled freelancer proficient in JavaScript and HTML. I currently possess a React filter, accessible via this GitHub link, that functions adequately. However, I aim to transform this React application into HTML and JavaScript to ensure compatibility with WordPress. Consequently, I require a freelancer capable of seamlessly rendering this React application into HTML, accompanied by the necessary scripts, and integrating it into a WordPress plugin. App link: ,net
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
I'm seeking a freelancer who can help with a data analysis project, translating numerical data from one sheet to another. - The main task for this project is copy texting, involving the transfer of numerical data. The ultimate goal is to enhance data analysis. This will require a high level of accuracy and attention to detail. - The results of the data analysis should be presented in the form of charts and graphs. Thus, experience with data visualization would be a great asset for this project. - The primary data type that you will be working with is numerical. Your understanding of numerical data and how to interpret it will be crucial for the success of this project.
Analizar Tabla de calculo de probabilidades de internet. Hacer lo necesario para comprender los calculos internos y poder replicarlos es un libro de excel. El trabajo comprende la hoja de Excel y la explicación de los calculos implicitos.
