Excel vba insert csv data access databaseงาน

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

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

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 experience with both AWS and WordPress. Familiarity wi...

I need someone proficient in C# to help create a Remote Administration Tool (RAT). This tool will primarily offer remote desktop access. A user-friendly graphical user interface (GUI) is a must, with a clear and clean design that's simple to navigate. It should be tailored specifically for a Windows operating system. Ideal Skills: - Strong background in C# - Experience in creating GUI - Expertise in remote desktop functionalities Experience: - Developing RATs - Working with Windows OS - Designing intuitive GUIs

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

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.

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-...developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API ...

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

We are looking to build a new website using WordPress which will link to our .net bespoke erp software which is currently being developed. As all our business is B2B, it’s very important for our customers to access as much information as they can online without the need to call our office. Features include: - Ordering products should be in grids for our customers to order - Customers to order embroidered/printed goods with product selection controls in place - Modern and attractive up-to-date designs - Customers should be able to view all their account information - Customers should be able to download copy invoices and credit notes - Customer should be able to pay online - Customers should see what’s on backorder for them including editing and cancel them - Livestoc...

I'm looking for a skilled app developer to create a cross-platform (iOS and Android) app. The primary goal of the app is to provide information. Key Features: - A user-friendly, intuitive design that makes accessing and browsing information easy and engaging. - Implement a login feature that allows for quick access to the app without requiring user registration.( Only for initial phase later there is a need of registration also for paid course) Ideal Skills: - Proficiency in cross-platform development, with experience in both iOS and Android. - Strong UI/UX design skills to ensure the app is intuitive and visually appealing. - Familiarity with implementing secure login systems. Experience in developing similar information-providing apps would be a bonus, as would a trac...

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

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

Just like the title says, i currently have a script on my site that displays text on mouse over, just not sure why it wont let me add line breaks; i can not give you access to the site, but i can send you the script. I have tried adding... '<br>, n, b, ' not really sure why its doing it. Thanks,

...2-Proficient in integrating and consuming RESTful APIs to enable seamless communication between microservices 3-Skilled in testing and debugging microservices to ensure high performance, reliability, and scalability Identity and Access Management (IAM) 4-In-depth knowledge and hands-on experience with at least one of the following IAM solutions: 1.1 -Keycloak. 1.2-Casdoor. 5- Strong proficiency in Python programming language 6- Expertise in developing RESTful APIs using the Fast API framework 7- Proficient in utilizing MongoDB as a NoSQL database for storing and retrieving data 8- Experience with containerization using Docker and orchestration using Docker Swarm for deploying and managing microservices 9-Experience in working with RabbitMQ as a message broker. BONU...

Design and implement one page website. The website shall have a d...any third party libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server...

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

...in need of a professional who can analyze comprehensive survey data and 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 docu...

I'm in need of a proficient and detail-oriented individual to execute data entry and organization tasks for less than 50 Arabic text documents, typically between 2-5 pages each. Key Responsibilities: • Data entry of Arabic text • Organization of entered data Ideal Skills: • Proficient in Arabic Language • Experience in Data Entry • Systematic and Organized Thinking • Ability to handle documents between 2-5 pages Your role will not only require entering data but also ensuring all information is effectively stored and easy to access. Prior experience with Arabic text data entry will be preferred. Manage resources responsibly and communicate promptly, as you’ll be working with less than 50 document...

Hi, I need assistance with installing a Public SSH key on my Linux server. The task focus on a single user who will need to access a specific folder located on the server. Key tasks to be completed include: - Enabling both write and read permissions for this user to that specific folder using its Public SSH Key authentification (without password). - The user should not have "execute" permissions or access to any other folders or areas. - Create a cron that will copy the content from this folder to another every 5min. The ideal freelancer for this job would have extensive understanding and experience with Linux command line, SSH configurations, permissions settings and security principles. Best regards.

...unauthorized access through a robust license key validation system. The ideal system will be capable of supporting both time-limited access (subscriptions) and permanent licenses. The successful freelancer should have: - Strong proficiency in C# and WPF - Proven experience in developing software protection systems - Expertise in implementing license key validation systems - Familiarity with both time-limited and permanent license structures - A good understanding of software security best practices Your role will involve: - Designing and implementing a license key validation system - Ensuring the system can handle both time-limited and permanent licenses - Building a user-friendly interface for license key input - Ensuring the system is robust against potential unauthori...

I need add an automatic stock control to Amazon, currently the catalogue is contained on a CSV

Due to time and resource constraints, I need to migrate a component written in php (symphony) to Golang. The part on github relating to services towards the DB (MongoDb) and the new REST APIs (written in Golang) to access for interfacing is already active. The system will only have to execute queries on MongoDb (via Service) and render in twig template. The repository layer and service and repository are already developed in golang and will be provided. As well as indications on the function to be translated into golang. GIT access will be via wireguard VPN on the development environment

I need a professional to mine data for me. I need you to download and extract the submissions and comments from a public Reddit dataset for 40 subreddits that I will give you. - Data Collection: Please extract the submissions and comments from this academictorrents link: https://academictorrents.com/details/56aa49f9653ba545f48df2e33679f014d2829c10/tech&filelist=1 I only want the comments and submissions for specific subreddits that I will supply to you. Please save the extracted data as csv file. - Frequency: This is a one-time job. Skills and Experience: - Torrent download and extraction.

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

...Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overwritten, preserving manually entered or previously fetched data. 4. Customization:...

I'm looking for an experienced Android developer to create a tablet version of my product catalog app. Key Features: - Offline Functionality: The app should be able to work without an internet connection, allowing users to access product information at all times. - Tablet-Optimized UI: The UI should be designed to provide an amazing experience on tablet screens, making use of the extra real estate and ensuring smooth navigation. - Multi-language Support: The app should support multiple languages, allowing users from different regions to easily understand and interact with the catalog. Ideal Skills: - Proficient in Android development, particularly for tablets - Experience with implementing offline functionality in Android apps - Strong UI/UX design skills, especially for tab...

I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

...of participating in opinion surveys more accessible and profitable for users. 1. Interface do Usuário (Frontend): Development of an intuitive and responsive interface for the overall administrative system and user back office. The overall administrative system should include pages for user management, transactions, surveys, and system settings. The user back office should provide easy access to personal data, token balance, transaction history, tasks performed, and direct referrals. Implementation of a personalized referral link for each user, allowing them to easily share the link to invite new users to the platform. 2. Backend e Lógica de Negócios: Development of a robust backend architecture to support the functionalities of administration and us...

I am seeking a skilled illustrations and graphic design professional to create impactful visuals for my website. I am a new adult sex blogger. I have a Wordpress hosted solution and access to themes. I am therefore not looking for theme creation from scratch in that respect. What I am looking for is graphics/illustrations and colors that I can add to my site to compliment text and help convey the page topic. Your Responsibilities: - Development of unique illustrations for website content - Creation of engaging graphics to enhance user experience - Work collaboratively on design concepts that complement the existing website aesthetics Ideal Candidate: - Open-minded in exploring diverse styles (minimalist, cartoon, realistic, etc.) - Proficient in modern design tools - Has an eye f...

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

PLEASE STOP SUBMITTING PLACEHOLDERS AND CONTACT US FORM, READ THE INSTRUCTIONS. IF YOU ARE NOT ABLE TO UNDERSTAND THE REQUIREMENTS, JUST DON'T SUBMIT ANYTHING. Screenshots; Company info, services and playground are few sections of the form - this is the form we need Sample and Sample Form just sampl...needs to be well-structured and easily navigable. Please see screenshot attached with the same of the bot configuration form. The form is a single HTML file and should remain like that. You must keep it clean and modern, you can look at our website and the contact us form (see screenshots attached). If you will provide design we like and have the right skills, you will be awarded the project, access will be provided to finalize the design. This form will be used as an iFr...

I'm immediately needing an Amazon S3 setup expert who can configure storage for a high volume of diverse files - images, videos and documents. Skills/Experience Required: - Proficiency in Amazon Web Services, particularly Amazon S3 - Capacity to handle and organize over 500 files ...documents. Skills/Experience Required: - Proficiency in Amazon Web Services, particularly Amazon S3 - Capacity to handle and organize over 500 files - Knowledge of best practices for managing and accessing files - Fast, effective setup in anticipation of immediate usage Tasks to complete: - Configure Amazon S3 bucket - Establish straightforward system for adding files - Ensure rapid, reliable access to all stored files Please only bid if completed projects involving Amazon S3 are showcased in ...

...extended timeline and the associated risks. - **Data Availability and Analysis:** As part of this project, you'll have access to our clinical trial data. It's essential that you can effectively incorporate this data into the model to accurately reflect the potential value of these drugs once they hit the market. - **WACC Calculation and Ratio Analysis:** The model should also include the calculation of the Weighted Average Cost of Capital (WACC) and relevant financial ratios. These will be crucial for determining the overall valuation of the company. Ideal candidates should have a strong background in financial analysis, with prior experience in the biopharma sector being a significant advantage. You should be comfortable working with complex da...

I urgently need access to an Instagram account to monitor its activities. It belongs to a friend of mine, and I hope to identify any suspicious behavior or potential issues. I'm looking to work with a professional who can help me gain access to this account ASAP. Ideal skills and experience include: - Expertise in account access and monitoring - Understanding of Instagram's security protocols - Discretion and professionalism in handling sensitive information Please note that I do not have written consent for this monitoring.

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

...project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that our core values and visual elements are consistently represented. - Format: The guidelines are to be presented in PDF format for easy distribution and access. Ideal Skills and Experience: - Proven experience in creating brand guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping h...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

...Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are using. Ideal Skills and Experience: - Proficiency in web design and development - Previous experience in developing inventory showcasing websites - Ability to create a clean and user-friendly design - Experience working with search and filter options on a website - Understanding of responsive web design and mobile-first approach Ul...

I'm looking for a detail-oriented researcher to help me gather infor...can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all...

...building and road data from OpenStreetMap in CSV format on a monthly basis or with a html frontend site, where we can "click" in Downloadbutton. Key requirements: - Automate the retrieval of building and road data from OpenStreetMap - Download the data in CSV format - Set up the system to run the download process on a monthly basis optimizely on html frotend with a download button Format of the csv: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber If available the Community and the Code of the Community Ideal skills and experience: - Proficient in OpenStreetMap data retrieval - Programming experience to automate data downloads - Strong understanding of CSV data f...

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally....

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

...provide us with your most insightful and deep feedback on various aspects including: - User experience - Key features - Onboarding process - Issues - Any other insights you believe are crucial - Suggestions for improvements But to participate, you need to: - Have a LinkedIn profile and use the platform regularly. - Be an everyday LinkedIn user to ensure unbiased feedback. How to Participate: - Access the tool and additional details via this link: - Spend 30-60 minutes exploring the tool and taking notes on your experience. - Submit your feedback in a Google doc, Word or PDF In return, for the most insightful and meaningful feedback we will not only give the reward of $25 but also write you a brilliant

...Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are using. Ideal Skills and Experience: - Proficiency in web design and development - Previous experience in developing inventory showcasing websites - Ability to create a clean and user-friendly design - Experience working with search and filter options on a website - Understanding of responsive web design and mobile-first approach Ul...

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.