Sql server express importing access työt

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.

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

Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.

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

server optimisation

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 ;)

...should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend dev...

Hello, I want a development. I want a touchscreen interface to control a cus...development. I want a touchscreen interface to control a custom vending machine. I need someone who has already worked on the MDB protocol for payment. My request is that a customer can access a touchscreen with 2 to 8 pictures. He select a picture, it send via the MDB protocol the payment request and if payment is accepted it launch a small PLC siemens logo program. I need a manager interface to change the prices, the number of sales available for each product and the photo of the product. We will load at the beginning all the possible photos so no need to add photos in the user interface. I need to be able to access from a browser to basic informations (number of products available, last sales...

I'm seeking an experienced system administrator to configure a Linux webserver that integrates Hestia Control Panel (CP). Key Deliverables: - Enable web hosting functionality for between 1 to 5 websites. - Configure email management services - specifically, the ability to setup email accounts and implement a solid spam filtering system. Ideally, the freelancers bidding on this project should have prior experience setting up and managing Linux servers and using HestiaCP. Knowledge of website and email database management, spam filtering techniques is a plus. Deliver reliable, secure, and high-performing results.

...feature into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I&...

I'm a business partner in a Bulgarian company and need to obtain a Certificate of Fiscal Residence. I'm not an onwer of the company. The freelancer I'm looking for needs to: - Have access to up-to-date information on the process of obtaining a Certificate of Fiscal Residence for a Bulgarian company. - Be able to find out if it's possible for a non-owner to obtain this certificate. - Determine if the process can be completed online and provide an estimate of the time it would take. Ideal qualifications: - Proficiency in Bulgarian and English. - Experience in legal research, particularly in the domain of fiscal or corporate law. - Familiarity with the specifics of Bulgarian corporate law and its procedures. Please note that I will need to be able to trust th...

I'm looking for a skilled web developer who can help reduce the Largest Contentful Paint (LCP) of our website to less than 2.5 seconds and also resolve JavaScript errors. Your task is to optimize the website to improve its overall performance. Key points to consider: - The current LCP needs to be reduced to under 2.5 seconds - You will have access to Microsoft Clarity for assistance which will provide metrics and the pages affected by the issues. - You also need to identify and address specific JavaScript errors (use Microsoft Clarity to assist). We will measure success of the task be comparing before and after Microsoft Clarity Metrics. Thank you!

...**User Registration**: The ability for users to sign up and create their own accounts. - **Daily Health Tips**: A feature that provides users with helpful health tips on a daily basis. - **Fitness Tracking**: The bot should enable users to keep track of their fitness progress. Key Features for the Web Application: - **Wellness Resources**: A comprehensive library of wellness resources for users to access. - **Appointment Scheduling**: An integrated system for users to book wellness appointments. - **Community Forum**: A platform for users to share experiences, ask questions, and support one another. - **Fitness Challenge**: A section dedicated to fitness challenges to keep users motivated. - **Nutrition Consultation**: A feature that allows users to get expert advice on nutritio...

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

I need an experienced Magento developer to help me set up my existing Magento 2.x site on a new server. - The job solely involves migrating the existing site to the new server. No customization or updates are needed. - I have access to both the source code and database of my Magento site, so you'll have everything you need for the migration. Please only bid if you have prior experience in Magento 2.x site migration. It's crucial that the migration is completed with zero downtime and no data loss.

I want to configure out attendance system with ZKteco Bio ADMS communicate with server 1) Send realtime attendance data from device to remove cloud server through PHP 2) Add user from server to device 3) delete user from server to device 4) finger store in DB and send to device when needed 5) Clear admin from device through api when needed Apply if you already work on such thing.

Use the latest Bootstrap 5 framework for the template. Responsive Design: Ensure the template works seamlessly on all devices – desktops, tablets, and smartphones. Photo Grouping: Create a system for organizing photos into groups and folders. Preview and Search: Implement image preview and search/filter options for quick access and management. Customization: Allow for easy customization of colors, layout, and other elements. Submission Guidelines Design Files: Submit HTML, CSS, and JS files. Demo Link: Provide a link to a live demo of your template. or a pic if you want Documentation: Include basic documentation on how to use and customize the template. Evaluation Criteria Design Aesthetics: Clean, modern, and visually appealing design. Usability: Intuitive and user-friendly ...

Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibili...

I'm in need of a proficient professional who can set up, configure, and manage a Windows-based virtualization server. The primary goal for this server is to host more than 10 virtual servers dedicated to running web applications. Key Responsibilities: - Configure and deploy a Windows-based virtualization server - Set up and manage over 10 virtual servers - Ensure all virtual servers are optimized for hosting web applications - Implement best practices for security and performance Ideal Candidate: - Proficiency in Windows Server OS - Experience with virtualization technologies (Hyper-V, VMware, etc.) - Background in managing and configuring virtual servers - Strong understanding of web hosting practices - Familiarity with security measures for virtual envi...

I'm in need of a professional video for my website. The goal is to introduce my website features in a clear and informative manner. Key requirements: - Screen recording with voiceover: The video should be a screen record...voiceover: The video should be a screen recording of my website, with a professional voiceover guiding the viewer through the various features and functions. Ideal skills and experience: - Experience creating similar videos for websites or software products - Strong scriptwriting and storytelling abilities - Proficiency in video editing and post-production - A professional voiceover artist or access to one Please provide references or examples of similar work you have done in the past. This will give me a better idea of your capabilities and suitability fo...

...organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous experience with similar projects is a plus. The successful freelancer will be able to demonstr...

As an experienced professional with more than a decade in the industry, I'm looking for software/full stack engineers who have a similar level of experience. The main goal of this project is collaboration. Skills Required: - Proficiency in Java, Python, C++, and JavaScript - Expertise in multiple front-end and back-end technologies including React, Angular, Django, Node, Express, and .Net - Excellent communication skills

I am searching for a skilled network specialist to help with various tasks related to my Unifi network setup. Key tasks include: - Installing three or more access points - Configuring specific network settings, encompassing DHCP settings, VLAN settings, and Firewall settings - Troubleshooting any potential connectivity issues Ideal candidates should be highly experienced with Unifi products, adept at network configuration and problem-solving. Your experience with DHCP, VLAN, and Firewall settings will crucially contribute to the successful completion of this project.

...some data into every new tab that opens. You can create new identities with ghost browser and give them a name. When the new tab opens in the new identity one of ghost browsers plugins injects an array of data. into the page and can be viewed in the console. I'd like to extract the ID, Name and Color values that it injects and store them in my chrome plugin but haven't been able to successfully access. Building the plugin I'm ok with but need help accessing these values. Here is the array that gets injected into each tab: { "active": {}, "bypassed": false, "info": [], "identityInfo": { "color": "BC789C", "creation_time": "2024-05-22T00:22:14.031Z", "id": ...

I'm in need of an ex...Conducting research and preparing reports Experience and Qualities Desired: - Proven track record as a virtual assistant, ideally to C-level executives - Strong organizational skills, with the ability to manage multiple tasks simultaneously - Excellent communication and interpersonal skills, to effectively liaise with team members and clients - Capability to work independently, in accordance with full access to confidential information - Proficiency in the usage of various communication channels including email, phone calls, and instant messaging/chat platforms The right freelancer for this role will be a proactive individual, capable of not only executing tasks but also suggesting improvements and strategies to facilitate more efficient and effective ...

I'm looking for an experienced domain broker who can help me acquire a premium domain urgently. Key Requirements: - The domain in question is a premium one, so experience in handling high-value domain transactions is a must. - You should be well-versed in the intricacies of domain sales, able to identify the right opportunities and negotiate effectively. - Your network and access to premium domain sellers is crucial for a quick turnaround. - While I have not specified the primary goal for this acquisition, a broker who can guide me in aligning the domain with brand recognition, SEO advantage, or a speculative investment would be an added advantage. Timeframe: - This is an urgent requirement and thus, I'm looking for someone who can broker this acquisition for me as ...

...Design Requirements 1. User Management -User Registration/Login: Separate workflows for candidates and companies. Each form should gather specific information as per the provided documentation. Design should clearly differentiate between these two processes. -Email Verification & Secure Password Management: Interfaces for email verification links and secure password reset options. -Role-Based Access Control (RBAC): Interfaces that reflect different user permissions for candidates, companies, recruiters, and admin roles. -Multi-factor Authentication (MFA): Design a toggle option in user settings for enabling MFA, and the authentication sequence involved in the login process when MFA is enabled. 2. Profile Management -Candidate Profiles: Design comprehensive digital resume...

...of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load on server and page doesn't hang? 7. Have you worked on any m...

I need an AI agent script that is browser based without a local computer install that will do two things. 1. Research current job postings on various job platforms based on my keywords and gather any emails as well and 2. Gather email for those related postings that did not have the emails in the posting by researching the agents. So these are either t...the output in a csv file with the name of business, job posting link, job category, name of contact if exists email address, phone number if exists. I only want the line saved if there is an email address. Again, I want something I can run from a browser without having to install python or anything in my computer. Please give a price for completing this project. If necessary I can provide access to a server if needed or to...

I am on the lookout for a researcher who can access and scan articles from a specific arabic language journal held in the Bibliothèque nationale de France. The journal was published in France. I have confirmation that it is held there. (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)

I'm looking for an experienced software developer to create an AI recruiting software tailored for the...Matching: A system to match keywords in resumes to job requirements - Machine Learning Algorithms: An algorithm to predict candidate suitability based on historical data Platform: - Web-based: The software should be accessible via any web browser for ease of use and accessibility - Mobile App: A mobile application should also be developed alongside the web version to allow recruiters and candidates to access the service on the go. Ideal skills for this project include: - Proficiency in AI and machine learning algorithms - Experience in recruitment software development - Knowledge of LMS and healthcare recruitment practices - Ability to create a user-friendly web interface...

I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving ...1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Looking forward to a fruitful pa...

I'm seeking an AWS expert to help me with configuring and optimizing my AWS server. Key Responsibilities: - Evaluate my existing AWS setup and recommend improvements for performance, security, and cost-effectiveness - Assist in configuring EC2 instances, S3 storage, and RDS databases as needed - Ensure the server is scalable, reliable, and can handle future growth Ideal Skills and Experience: - Proven experience with AWS services, particularly EC2, S3, and RDS - Deep understanding of server optimization, security, and scalability - Excellent troubleshooting skills and an ability to work proactively to prevent issues - Familiarity with best practices for cost-effective AWS usage - Strong communication skills and the ability to explain complex technical concepts ...

I'm looking for a versatile video creator to join our team. The ideal candidate can be skilled in dancing, singing, makeup, saree draping, voice mimicking, and acting, etc. You just need that CREATIVE BUG! Whether you're a fresher, a housewife, or a remote worker, we would love to see your resume and portfolio. Key Requirements: - Love to express yourself - Comfortable in front of camera - Be Creative - Good Communication Skills Monthly payments will be made for your contributions. If you're passionate about creating diverse and engaging content, we would be thrilled to have you on board.

I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.

I'm in need of an architect to design a modern style triplex villa. The total area is 110 square meters and the project is expected to be a contemporary, sophisticated a...means ensuring there's a balance between communal areas and private spaces. - Incorporating key features such as a private garden or terrace, multiple balconies and rooftop access. These features are essential and should be integrated seamlessly into the design. Ideal candidates for this project should: - Have a strong portfolio of modern architectural designs - Possess experience in designing triplex villas and with a mix of open plan and separate rooms - Demonstrate creativity and innovation in the use of space - Be able to understand and incorporate essential features like private garden, balconies,...

...$399/month) 20% commission on the monthly revenue generated by Tier 3 clients (client pays $599/month) Bonus Structure: $250 bonus when a client reaches 3 months $500 bonus at 6 months $1,000 bonus at 12 months Earnings Potential: Our top performers can earn $1,500 - $3,000+ per month within the first few months. The more clients you acquire, the higher your passive income grows. Tools Provided: Access to cutting-edge lead generation tools Sales scripts, email templates, and resources to streamline your outreach Responsibilities: Identify and reach out to potential clients through targeted campaigns Conduct research to build prospect lists and identify decision-makers Deliver compelling sales presentations showcasing our value proposition Close deals and onboard new clien...

As a client, I have full access to the financial statements and data required for this project. I am seeking a proficient professional who can conduct a comprehensive valuation for a listed company using three different models; Discounted Cash Flow (DCF), Gordon model, and residual income. The project should be conducted with a 5-year timeframe in mind. Key Deliverables: - Thorough valuation of a listed company using DCF, Gordon model, and residual income - Clear and well-structured report detailing the results and rationale of the valuation - Analysis that corresponds to a 5-year timeframe Ideal Skills and Experience: - Strong financial analysis background with experience in valuations - Expertise in using DCF, Gordon model and residual income for company valuation - Ability to ...

I am in need of a professional website developed to showcase my academia-focused content. The site should be specifically designed to highlight my research publications. Key Features: - Display of Research publications: These should be presented in a clear, easily navigable way. Each publication must have its abstract summary and a link to access the full text PDF. - Organization: The publications should be organized by research topic, allowing visitors to quickly navigate to their areas of interest. Ideal skills for the job: - Web Design: You should have a portfolio demonstrating your ability to create professional, clean, and user-friendly sites. - Content Management: Familiarity with content organization is crucial, specifically in handling academic or research materials. Over...

...looking for the product to then be purchasable following that quotation following a sign up process and agreement to terms and conditions. Customer will then automatically be sent an email welcoming them to the product and will include policy details. I will need functionality to bill customers monthly using card payment and to include a cancel anytime option. I absolutely need free-flow access to the site and the ability to make frequent changes. Therefore upon completion I will be looking to employ the designer for regular maintenance and change updates throughout the lifetime of the site. When up and running I would look to communicate mainly through whatsapp for ease of communication. A crucial requirement is for my designer to speak very good English please. K...

I need an experienced web scraping expert who can help me scrape relevant data from a specific website on a daily basis. Key Details: - I'm looking for data in text format including headlines, product descriptions, and any other relevant information available on the site. - There is no requirement for authentication to access the data, so the process should be straightforward. - The extraction needs to happen daily, so you should be able to set up a recurring scraping process. Skills and Experience: - Proficiency in web scraping tools and techniques. - Experience in extracting text data from websites and setting up automated daily scraping routines. - Good understanding of data formats and storage to deliver data in a usable format. I'm looking for a reliable and effic...

I need a simple web application developed using the Scriptcase platform. The main functionality of the project will be integrating a database into the application. This will include data for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating da...for user profiles and product listings. Key Requirements: - Development experience with the Scriptcase platform is a must - Proficiency in PHP and web application development - Experience in integrating databases into web applications Other Details: - The application must be user-friendly and intuitive - No specific user roles or permissions are required, all users will have the same level of a...

...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...

...create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the other with full access for any required changes. **Requirements:** **Tab 1: Welcome & Data Collection** *Design and User Interface:* - Create an inviting and user-friendly interface that reflects our professional standards, incorporating the company logo colours (blue, white, grey). - Ensure intuitive navigation and seamless data entry for clients of varying technical abilities. Buttons for each