Import excel data vb net sql 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...

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

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.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

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.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution j-net solution

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.

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

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I'm looking for someone proficient in data entry to help me transform scanned PDF documents into an organized spreadsheet format. Ideal Candidate: - Proven experience in data entry from PDF to excel or similar - Precise attention to detail to ensure accuracy of the data - Efficiency to meet deadlines with minimal supervision Principal Duties: - Convert scanned PDFs into an Excel spreadsheet - Focus on extracting and entering text content from the PDF documents - Maintain the overall integrity of the original information - Ensure the accuracy and reliability of the final spreadsheet data

...little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the Smartsheet and create Dashboards for multiple audiences. Ideal candidates should have: - Expertise in Smartsheet - linking Smartsheet plans to external data - Linking Multiple Smartsheet project plans that share tassks - Proficiency in...

I'm in need of a serious, detail-oriented freelance virtual assistant for some important data entry tasks. Key Requirements Include: - Specialized in data entry, with strong attention to detail. - Experience with Excel spreadsheet is compulsory because all text-based data entry will be done here. - As this is text based data, a great understanding of English and excellent typing skills are required. - Being well-organized, disciplined, honest and able to complete tasks on time is essential. This job is suitable for someone who enjoys data input tasks with a knack for precision, consistency and quality of work. If you meet these requirements, I want to hear from you!

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems...

I'm seeking an experienced customs agent well-versed in importing a wide va...Handling clearance for all types of goods imported from China - Assuring all necessary paperwork and processes are accurately completed Required Expertise: - Extensive experience in import clearance - Prior work with electronics (including computer hardware, household appliances, and audio/video equipment) - Knowledgeable about import procedures for apparel and machinery - Familiarity with China's export procedures This project requires strong attention to detail, an understanding of international trade logistics, and familiarity with China's export systems. The ideal candidate will swiftly navigate spanish import clearance processes, ensuring that products reach their final ...

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...

I'm looking for someone to help me organize and input my personal finance data into an Excel sheet. The Excel sheet is intended to be a combination of both summary and itemized details. This means that your work will involve both categorizing transactions, and summarizing them by month or year. This project requires a good understanding of personal finance, as well as data entry experience. The ideal candidate should be able to work with sensitive financial information and must be able to keep this data confidential. If you have experience in personal finance or accounting, and can handle this kind of detailed data entry, I'd love to hear from you.

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

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

As an experienced developer, my goal is to connect my existing trading BOT, already linked to Bitstamp, to Kraken API. The chosen candidate should be proficient in .NET, particularly .NET Core. Key Responsibilities: - Connect my BOT to the Kraken API using .NET Core - Implement functionalities for trade execution, market data analysis, and account management Ideal Skills: - Proficient in .NET, particularly .NET Core - Previous experience with API integration, preferably in the trading sector - Strong understanding of trade execution, market data analysis, and account management - Ability to troubleshoot and optimize the integration process for a seamless user experience. If you have the necessary skills and are confident in your ability...

Hi there. I ...page that allows me to say IF somevariable = current displayed letter, then move to next. Basically, the function would help me create a way to automatically change the letter to the next letter IF some condition exists, which I will handle myself and assign to the variable you create. IF $somevariable = $current_letter THEN move to next letter I would like you to use auto-layout, so I can import this into the App I want to and use it for iPhones or iPads. I'm using XCode 15.3, so I need to be able to run the App in that. Thanks! And, I need this asap. Then I need you to show some images/layers IF the $somevariable function is correct and other images IF the $somevariable is incorrect (see attached images). It's sort of like a simple Learning Exercis...

I'm looking for a Zoho expert who can help me with improving my inventory management, streamlining sales and customer relationship management, and increasing overall efficiency and productivity. Looking to build a template platform that will be recreated across multiple companies. Key Responsibilities: - Assist with data import/export in Zoho Inventory - Customize fields and layouts in both Zoho Inventory and CRM - Integrate Zoho Inventory with my existing CRM system and sales tracking system Ideal Candidate: - Proven experience with Zoho Inventory and CRM - Strong understanding of inventory management principles - Experience in customization and integration of Zoho systems - Excellent communication and problem-solving skills Your assistance will significantly help me...

...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...

...high-quality standards, top ratings, and good reviews (4.5 and above), and with the lowest price and the shortest delivery time frame to the UK (4 to 7 days). 2. Once you have identified the best products, import them into Dser and edit them before importing them into Shopify. It is crucial not to push products to Shopify without first editing them on Dser, including the SEO-optimised content in each product description. Add videos to the products for better customer engagement. Additionally, balance the different brands and avoid populating a category with mainly one brand. 3. Import reviews and optimise SEO, as these are essential. 4. Avoid listing products with non-English language descriptions, images, or videos. 5. Also, do not list products with suppliers like Al...

I am in need of a react-native whizz who can figure out and solve the error messages plaguing my project post SDK upgrade. ...solve the error messages plaguing my project post SDK upgrade. Detail-oriented and aggressive troubleshooting skills are a must for this job. Since upgrading my SDK from version 50 to 51, my project has been inundated with errors. My dependencies are up-to-date and compatible with the new SDK version, but a solution remains elusive. The errors appearing are related to syntax issues and styles import (hermes) Ideal Skills: - Extensive experience in react-native - Comprehensive understanding of SDKs and upgrading processes - Excellent debugging capabilities Nobody likes bugs, so let's squish this one fast. Looking forward to working with an enthusiastic ...

I am looking for a skilled modder who can reskin two characters from Total War: Three Kingdoms - Lu Bu and Diaochan. The work involves the following specifics: - Complete reskin of both characters with existing texture and model files - Import of model and texture files that are already available - Making sure that .pack file (mod) is applied to correct characters Ideally, this project should not take more than a day to complete, and it requires basic knowledge of modeling for the successful import of the model and texture files. Total War: Three Kingdoms Character Reskin Mod for the game in "pack" format, suitable for the game and fully functional for the game and compatible with other mods. made for last version for the game. I will provide files for both char...

I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, inclu...

...number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service where it is possible to obtain the user's total coins and record of consecutive days marked; Screen 1: - When opening the app, if there is a project started, jump to screen 2. If not, list projects. - The user must choose a project from the list on the first screen to continue and start. - Get list data via http from

I'm in need of a unique plastic rectangular frame with a net for a beach game. The net will be used for a game similar to spikeball that will be played on the beach. It is similar to a a game called beer dye commonly played at colleges so I need to have 4 holes in each corner that can hold a ball similar to how poole is played where the balls fall in a hole Key requirements: - The frame should be durable, water-resistant and suitable for the beach environment. - The net should be of high quality and appropriate for game play. - The overall design should be innovative and engaging. The ideal freelancer for this project would have experience in: - Industrial design with an emphasis on sports equipment or outdoor products. - Fabrication of plastic product...

I need someone who can research the regulations for importing and selling industrial RFID reader in Hong Kong. A brief report needs to be made with the following information: 1) Regulations related to the import of RFID reader ・ Approval and license that importer and distributor are obliged to obtain prior to the import and selling of RFID reader (such as OFTA license) ・ Related laws and regulatory authorities 2) Regulations and standards related to the sale of RFID reader, such as Quality standards or quality requirements, Environmental requirements (RoHS etc.) that need to be satisfied (if any) ・ Regulations regarding labels (labeling requirements, if any) ・ Each report needs to be made in English and will be of about 4 sheets of A4 paper (about 2,000 words). I want the ...

I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyz...

I'm looking for a skilled developer to optimize my .NET and Angular project. The main areas I need improvement in include: - Performance: The project currently suffers from slow loading times. I'm looking for a professional who can optimize the code to ensure faster loading speeds. - Code Structure: The backend code in particular requires attention. I want to restructure it for better readability and maintainability. - Routing and API Optimizations: I need someone to optimize routing and API calls to decrease loading times and improve overall project performance. -Lazy Loading, Eager Loading optimizations Ideal candidates will have: - Proficiency in .NET and Angular - Experience with optimizing projects for performance, especially in addressing slow loading times -...

I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.

...asking targeted questions, and gathering and reporting certain information in Google Sheets. Required: Availability from 9a-5p EST on 5/13 and 5/14, ability to make ~500 domestic calls from US cell phone/number. Key Responsibilities: - Conduct a series of cold calls to to pool service companies to collect data on their business statistics (size, etc.) and software usage (offering $USD incentive for participation) - Collect feedback on which specific Swimming Pool software they use, Net Promoter Score (NPS), Likelihood to Switch to a different software platform, etc. - Document the feedback accurately in Google Sheets - Schedule interviews via Calendly (offering $USD incentive for participation) Ideal Skills and Experience: - Background in US telemarketing - ...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled...

...experienced .NET developer to help me build a cloud-based web application. I haven't settled on a specific type of database yet, so I'm looking for your expertise to guide me in selecting the most suitable option. The application should be developed using .NET Core and should include a Web API. Key Requirements: - Database Selection: I'm currently undecided about the type of database to use for the application. Your input in selecting an appropriate database will be much appreciated. - User Authentication: I would like the application to have user authentication capabilities, preferably integrated with popular social media platforms. - User Management: The web application should have user management functionalities. The ideal candidate for this project sho...

...predictive analytics, and automated scheduling to optimize the allocation of available during periods of scarcity Problem Definition: The issue of electricity shortages has always been an issue in Zimbabwe, there has always been a gross imbalance between the electricity available and the demand for it. Due to the depressed local power generation coupled by increased electricity demand as well as power import constraints, it means that the country will not be able to meet the demand for electricity Requirements or Objectives: - User Registration and Login: The website should allow users to create accounts and log in securely. - Schedule Display and Updates: It should display the scheduled power outages in different areas. - Notification Alerts: Users should receive timely notifi...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...