Excel vba database connection odbc error jobs

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

Please Sign Up or Login to see details.

Error when login. Fix it only. With ftp

Description: I'm seeking an experienced AWS and Django developer to urgently fix a "502 Bad Gateway" error that started occurring on my Django-based website hosted on an AWS EC2 instance after an IAM role change. The task will also involve reviewing and revoking AWS access previously granted to a developer, and ensuring the site's security and integrity. Responsibilities: Diagnose and resolve the "502 Bad Gateway" error. Review and modify IAM permissions to ensure both security and functionality. Confirm that all components of the AWS environment (like EC2, RDS) are properly configured and interacting without issues. Ensure the Django application is securely configured and fully operational. Provide a brief report on the changes made and any re...

...different camera setups. The system should support settings for either two-way or single direction vehicle detection, selectable per camera. Multi-Camera Support: The application must handle live feeds from at least three cameras simultaneously without frame skipping. Ensure seamless capturing, detecting, and tracking across all cameras, maintaining high accuracy and performance. Error Handling: Implement robust error handling to ensure the application runs continuously without crashes. Auto-recovery features should be included to handle and log stream interruptions or other common errors. RTSP Streaming Compatibility: Must support RTSP for fetching live video feeds directly from IP cameras. Compatibility with different camera manufacturers and models should be considered....

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

...function and durability for horse and rider. My saddle blankets run a panorama of colors, from the elegance of the "Asheville" design with its’ soft pink and grays to the bold blend of firey colors in "Fireball Whiskey". After a decade of creating original, show stopping, designs in my hand woven cinches and breast collars, moving to unique saddle blanket designs came naturally. My deep connection and love of all nature are key inspirations in my designs. Wild Ride Saddle Blankets will shine in the Show Ring, on the Ranch and on the Trail. “Wild Ride” saddle blankets are for those who understand quality, hard work and an entrepreneurial spirit … for the MAVERICKS, the true-hearted who aren’t afraid to stand out in a cr...

I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!

I am facing an issue on my Windows system where the internet disconnects every time I connect to my OpenVPN. This issue is significantly impacting my ab...OpenVPN. This issue is significantly impacting my ability to work remotely and access the resources I need. Key Points: - The issue started occurring when I began using OpenVPN. - I work on my system and the VPN is a critical part of my workflow. - The problem is specific to my Windows operating system. I am looking for a professional who has: - Profound experience with troubleshooting VPN connection issues, especially with OpenVPN. - Strong knowledge of Windows operating system networking and its interaction with VPNs. - Excellent communication skills and can guide me through the troubleshooting process in a clear and understan...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

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.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The G...the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm in need of someone adept at PHP and SOAP. My development site is currently returning a warning message: "Attempt to read property "Invoice_Number" on string." I've set up a dev SOAP server for you to carry out the work. At this point, I'm uncertain if I'm attempting to access the "Invoice_Number" property on a string. There are also no other error messages accompanying this issue. Key tasks: - Identify the cause of the "Invoice_Number" warning - Fix the PHP SOAP warning Ideal skills: - Proficiency in PHP - Experience dealing with SOAP - Ability to troubleshoot and resolve such issues promptly

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate

...technology, MetaMatch aims to revolutionize fan interaction with sports through the integration of NFTs and real-time event engagement. The logo should encapsulate the essence of blending traditional sports with cutting-edge blockchain technology, appealing to both tech-savvy and sports-loving audiences. Specific Requirements: Concept and Design: The logo must convey a sense of innovation and connection, symbolizing the fusion of real-world sports and blockchain technology. It should be modern, easily recognizable, and scalable for use on various platforms and sizes. Color Scheme: We are looking for a color palette that stands out yet feels intrinsic to both the digital nature of blockchain and the dynamic energy of sports. Suggestions include, but are not limited to, combinat...

I'm seeking a skilled WordPress developer to troubleshoot and fix an issue on my WordPress site running the version 5.0 or later. The problem seems to be affecting Gamipress, Progress Maps, and Co-Blocks plugins. Key Details: - Problem: Progress Maps and Progress Bars not updating - Error Message: Fix co-blocks error "cannot be rendered" message on site - Recent Changes: No recent changes have been made, but the issues have occurred The ideal candidate should have: - Proven experience troubleshooting and resolving WordPress plugin issues - Specifically, experience with Gamipress, Progress Maps, and Co-Blocks would be a bonus - A deep understanding of WordPress 5.0 or later and its intricacies Looking forward to hearing from professionals who can swiftly res...

We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.

We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.

...published on a separate WordPress site. Ideal skills for this project include: - Strong understanding of WordPress development - Experience with creating custom plugins - Familiarity with WordPress APIs and data handling - Ability to work with cross-site data transfer The project requires: - Setting up a user-friendly form for registered users on Website A to create posts - Establishing a connection between Website A and Website B for seamless post transfer - Ensuring the posts are published immediately on Website B I'm open to your suggestions for user information that could be included in the post transfer, and I would appreciate your input on best practices for this kind of cross-website integration. Your input on potential security considerations for such integrati...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.

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...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

I am in immediate need of a skilled AWS developer to address various issues in my application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing securi...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I'm having a peculiar problem with 3ds Max where I can't seem to save my finished renders. There is no error message popping up, which makes it all the more confusing. I've tested other file types, and they save just fine; the issue only occurs with the finished renders. I need a freelancer with a strong understanding of 3ds Max, experienced in troubleshooting, and ideally someone who has encountered and resolved this issue before. It is critical to me that this issue is resolved promptly while ensuring no data loss - the integrity of my existing files is of utmost importance.

...of SKUs with the following columns (category, sub_category, brand, sku_name, description, competitor_name, datetime, location, url, nsp, psp, stock_count (if available), popularity_index (if available), weight (if available). If one SKU is contained in more than one category/sub_category, present the same SKU in different rows. Unit tests The scraper must include unit tests that cover main and error test cases, including optional parameters Submission The following must be submitted: - Scraper code and unit tests - README file for running and deploying the scraper - Output of all SKUs from the 3 online grocery apps specified above Project Acceptance Testing The scraper output will be manually verified within 24 hours of submission and SKU list must be 95% accurate. The SKU lis...

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 ...

I am in need of an experienced Vue.js developer who can quickly fix my Vue 2.6 application. When I click on a button to go to another page it works fine in development but when I deploy it gives a 404 error. I need this fixed as fast as possible. When you respond to this posting please put "I CAN DO IT" at the beginning of your bid. I don't want to waste time with automatic bids that nobody answers. And please bid honestly and not low ball then ask what's your budget. I will upload the project when I find a person

As the owner of a website, I am currently experiencing a critical issue where the destination is not working error blocks the ads from publishing. I need someone with expertise in this regard and help me resolve the issue

Finding Someone Who can Solve this error (One site is sending me callbacks and in 10 callbacks theyre getting this response in 5 callbacks and rest 5 callbacks are working fine) <?xml version='1.0' ?> <env:Envelope xmlns:env=''> <env:Body> <env:Fault> <faultcode>env:Client</faultcode> <faultstring>Internal Error</faultstring> </env:Fault> </env:Body> </env:Envelope

As a friend group planning a lively bachelor party, we're searching for an enthusiastic individual who could step into the role of a w...individual who could step into the role of a wiffle ball game umpire for approximately 2 hours. Minimal baseball knowledge and rules required. Balls and strikes not required, just things like safe and out. Key Responsibilities: - It would be great if you’re able to provide some commentary throughout the game, similar to a game commentator. You can make fun of anyone who swings and misses, or makes an error; things like that. It’s very informal, but the more lively, the better. Necessary Skills and Experience: - Understanding of basic baseball rules like safe and out. - Energetic, fun-loving, and enthusiastic attitude. - Excell...

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have exper...

Help me publishing an Net6+ReactJs Project to IIS More details: Which version of Windows Server are you using for hosting the application? Windows Server 2012 Can you describe the specific problems or error messages you receive when attempting to deploy to IIS? SPA not launching when publishing to server folder: https//localhost:44321 works Have you ensured that the necessary files and dependencies for your React app are included in the published folder? Yes, I have checked and all necessary files are included

...- python3 -m pip install depthai 6. Then I cloned the "depthai-python" git hub repository 7. Then I ran the install requirements (still in the environment) - python3 Finally, I tried to run the example code ColorCamera/rgb_preview.py. However, I would run into the error, "RunTimeError: No avaible devices." Originally, I thought this was a watchdog error since the it said "RunTimeError" but the watchdog timer only activates after 15 seconds and the terminal returns this error in less than 5 seconds. On Luxinos's documentation I noticed that if the camera is unable to connect to the DHCP server it has a fall-back IP Address, 169.254.1.222. Using my computer, I was able to run a script that gives me the IP address of the camera ...

...- python3 -m pip install depthai 6. Then I cloned the "depthai-python" git hub repository 7. Then I ran the install requirements (still in the environment) - python3 Finally, I tried to run the example code ColorCamera/rgb_preview.py. However, I would run into the error, "RunTimeError: No avaible devices." Originally, I thought this was a watchdog error since the it said "RunTimeError" but the watchdog timer only activates after 15 seconds and the terminal returns this error in less than 5 seconds. On Luxinos's documentation I noticed that if the camera is unable to connect to the DHCP server it has a fall-back IP Address, 169.254.1.222. Using my computer, I was able to run a script that gives me the IP address of the camera ...

opencart site has error, need to fix that More details: What specific issue are you experiencing with your Opencart site? Error messages on the site Could you specify the nature of the error messages appearing on the site? Server related errors What kind of server-related errors are you experiencing? other

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I'm looking forward to resol...

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...

I'm in need of a proficient expert who ...Web Panel, VPS servers, and FileZilla. I own a VPS web server which I am having difficulties connecting to via FTP. The ideal freelancer for this task should have knowledge of: - Hestia Web Panel, and its API and configurations - How to effectively troubleshoot VPS servers - FTP access through FileZilla With this project, I need: - Full diagnosis and resolution of the FTP connection issue - Restoring the connection between the Hestia Web Panel and the VPS server via FTP - Ensuring there's seamless access to the VPS server Note, I can access the VPS server through SSH, thus you should also be comfortable working with SSH connections. Your expertise in resolving this connectivity issue would highly contribute to the smoot...

I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

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...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...