Excel vba odbc connection työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Moi! Etsin 16h takarajalla kykenevää Englanti-Suomi -suomentajaa. Minulla on 1 trellotaulu virtuaalityöpöydällä suomennettavana englannista suomeksi, johon annan kirjautumistiedot, jota ennen lähetän linkin ohjevideoon miten toimia koneella. Macilla Microsoft Remote Desktop toimii, Windowsilla normaali Remote Connection riittää kirjautumiseen. Budjettini on tälle 15€ tuntipalkka. Työpöydällä on ajantrackaussofta jonka kautta maksetaan palkka. Maksan taskista vähintään 50€ vaikka taski veisi vain 2-3h. Jos pystyt tekemään tämän minulle seuraavan 16h sisällä ja haluat taskin, kerro. Laitan sitten 3min kestävän Loom -videon linkin jonka kuvasin...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cle...some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry a...

...to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. This project is very large, so I would like to start with a very high-level review of my concept: Current job and price is for 1) The review of a 2-page outline of my development project, up to (6) PDF and/or Excel documents that are currently in use, and (1) Excel-Based production tracker that attempts t...

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...

...feature for local community engagement. Ideal Candidate Skills & Experience: - Proven experience in designing social networking platforms. - Knowledgeable with contemporary UI/UX trends and guidelines. - Proficient in using design tools like Sketch, Figma, or Adobe XD. - Experience in designing both web and mobile applications. This project requires designing virtual interactions that foster connection while facilitating business services. Your designs will be intuitive, easy to navigate, and promoting user engagement. Specific mockup pages: Home page A. Live Feed: The platform should include a live feed where information can be posted, share, uploaded, linked or saved to a desk top. B. Individuals: In order to use the live feed, an individual would have to register on ...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

I'm searching for an experienced LinkedIn lead generation professional, adept at cultivating B2B connections within the technology industry. To be successful...will need: - Proven experience in B2B lead generation, particularly within the technology sector - Demonstrate strong understanding of LinkedIn's features as a networking and lead generation tool - Ability to effectively target potential leads, with the understanding that the user did not specify a focus on job titles or roles Ideal candidates will have a track record of creating significant connection growth, generating leads that convert, and providing comprehensive reports on their process and success rates. Please provide examples in your proposal where you have done this in the past. Looking forward to a pote...

As someone who's already attempted to debug a Twilio-Python project, I'm in need of an expert who can navigate the issues I've run into. Key responsibilities will include: - Debugging already available code - Addressing connection problems between websockets and Twilio It's crucial that you're proficient in Twilio and WebSocket protocols, as well as Python version 3.x. As the code is already written, your main task will be to figure out what's causing the integration issues and solve them. If this sounds like something you can confidently handle, I'd love to hear from you.

Error establishing a database connection This either means that the username and password information in your file is incorrect or that contact with the database server at localhost could not be established. This could mean your host’s database server is down. Are you sure you have the correct username and password? Are you sure you have typed the correct hostname? Are you sure the database server is running? If you are unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress support forums.

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

I need a simple code to conect a accdb file with password in visual basic 6. It´s very simple. I need a code working with Visual Basic 6 SP6 The connection need to be by code.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

Description: We are seeking an experienced professional in networking to configure a Site-to-Site connection using OpenVPN Cloud Connexa between two distinct Internet Service Providers (ISPs). The primary objective is to establish seamless communication between two separate networks for efficient data transfer. T Key Details: Objective: Enable communication between two separate networks for seamless data transfer. OpenVPN Cloud Connexa Experience: Substantial personal experience with the platform. End Result: Connect two different devices, each with a private network, via Team Viewer private LAN. This connection should be established without any public access, ensuring privacy and security. Ideal Candidate Skills and Experience: Proficiency in configuring Site-to-Site co...

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...

I'm seeking professionals...as the client hasn't specified whether it's for charging devices faster, developing a new charging technology, or creating a fast-charging product. We're unaware of the devices it will be compatible with; therefore, the professionals will need to decide if it will work with smartphones, tablets, laptops or all of these devices. The connection type to devices hasn't been stated by the client. The freelancer will need to decide if it will use a wired connection, wireless, or both. Requisite skills: - Strong experience in product development - Technical knowledge of charging technologies - Decision-making abilities as client provided minimal specifications - Flexibility to adapt to unforeseen project requisites - Strong k...

I'm seeking a meticulous data entry professional who can convert physical documents filled with text data into an Excel spreadsheet. Key Requirements: - Conversion of physical text data documents into an Excel spreadsheet - High level of accuracy and attention to detail to ensure the data is entered correctly - Ability to maintain data confidentiality - Must be able to meet deadlines Ideal Skills: - Proficient in data entry and managing data using Excel - Excellent attention to detail to ensure the accuracy of the entered data - Previous experience in handling sensitive or confidential information - Ability to meet deadlines and ensure timely delivery of the project - Strong communication skills to provide updates on the progress of the project

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

...sanitation. Fire protection system designs, including sprinkler layout, pipe sizing, and location of control valves, in compliance with NFPA codes and local regulations. Gas detection and ventilation system designs if applicable, ensuring safe operation of the facility. Specifications for mechanical equipment such as chillers, pumps, and water heaters, including their capacity, location, and connection details. Coordination with structural and architectural drawings to ensure proper placement and support of mechanical equipment and penetrations. Coordination and Integration: Ensure coordination between electrical and mechanical systems to avoid conflicts and optimize space utilization. Integration of electrical and mechanical systems with architectural and structural elements of ...

With I can connect to the websocket via the web browser. But I want to connect to this socket with nodejs, unfortunately I couldn't get a successful connection. I am ready to pay a fee to an experienced websocket and autobahn person just for a successful connection to websocket.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

Necesito un excel simplificado y parametrizado (formulado) para comparar si vale la pena comprar o alquilar una propiedad, según gastos y costo de oportunidad.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...current logo and designing related brand materials such as flyers, advertisements etc Key requirements: - Strong emphasis on creating a bold and vibrant tone for the label and brand materials - Familiarity with designing for family, young adults and South African tourist- oriented products - Incorporating a product origin story/feeling into the label design to establish a personal and cultural connection with the audience - Including a spiciness level indicator to convey the heat level of each variant in a clear and engaging way. - Ingredients and allergens - packaging size/volume - QR code guiding to website & contact details Ideal skills for the job: - Graphic design expertise with a proven track record of successful label and brand design work - Experience working with f...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I need an experienced email marketer to help increase sales through promotional emails. Key tasks for the project are: - Creation of captivating promotional content intended for both existing and potential customers. - Ensuring all emails are designed with the aim of increasing traffic and turning leads into sales. The ideal freelancer for this job will have: - Prov...designed with the aim of increasing traffic and turning leads into sales. The ideal freelancer for this job will have: - Proven experience in successful email marketing campaigns - A strong understanding of sales techniques - Immense creativity in copywriting - Knowledge of customer engagement tactics. It's important these emails not only drive an increase in sales but also build a stronger connection wit...

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

I urgently require an expert in scientific poster design for a mathematics conferenc...Conference website is Your design must be visually appealing, professional, and communicate complex concepts clearly. Key Requirements: - Ability to incorporate conference details into the design - Creation of a visually appealing background to make the poster stand out - Capacity to deliver the completed poster as a high-resolution, print-ready file - Poster must bring some connection to the organizing country Armenia Ideal Experience: - A background in graphic design, especially experience designing posters for scientific, academic, or professional purposes - Familiarity with the field of mathematics will be a major advantage - Proved experience of working under tight deadlines.

I'm in need of a Social Media Expert who can guide me on integrating my Facebook and Instagram pages with three different websites. I'm looking to improve my social media presence and would like to be able to post content directly from the sites. Key Responsibilities: - Advise and guide on the integration process - Ensure seamless connection between social media pages and websites - Provide recommendations on best practices for posting content Ideal Skills and Experience: - Proven experience with Facebook and Instagram integration - Strong understanding of social media and website connectivity - Excellent communication and consultation skills

I'm looking for a capable designer who can create a modern style title card for a jukebox. Key Requirements: - The design must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Numbe...

I need a professional who can resolve a persistent issue I'm experiencing while connecting my GoHighLevel whitelabel account to Cloudflare. Your primary task is to troubleshoot and fix the 1014 CNAME Cross User Banned Error that repeatedly occurs during the connection. I have full access to both my Cloudflare and GoHighLevel accounts, so you can freely work on resolving the issue. The ideal candidate for this project should have: - Profound knowledge and expertise working with GoHighLevel and Cloudflare - Extensive experience in troubleshooting and resolving CNAME errors - Excellent problem-solving skills I need this issue resolved promptly to ensure seamless connectivity between my GoHighLevel whitelabel account and Cloudflare. Please only bid if you are confident in your ...

...not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day i...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs