Find Jobs
Hire Freelancers

Create VB script for exporting Excel to SQL

$10-30 AUD

Ukończony
Opublikowano około 8 lat temu

$10-30 AUD

Płatne przy odbiorze
I am needing a macro script written, that will upload rows and specified columns of data from an Excel 2010 spreadsheet into an existing SQL table. Please outline your approach in your bid.
Identyfikator projektu: 9469051

Informację o projekcie

36 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
If you provide me with Excel spreadsheet, I can convert it to SQL database or I can make a script for you which will copy data from Excel spreadsheet to SQL database (You need to provide SQL table structure).
$30 AUD w 1 dzień
5,0 (2 opinii)
1,7
1,7
36 freelancerzy składają oferty o średniej wysokości $45 AUD dla tej pracy
Awatar Użytkownika
Hello, I am very much interested to do this work as i have strong knowledge in VBA as well as sql server related works. I understand your work and i think i can do it efficiently. Thanks
$28 AUD w 1 dzień
5,0 (356 opinii)
7,9
7,9
Awatar Użytkownika
Hi, I am planning to make use of VBA in Excel with connectivity to SQL table to transfer data from Excel to SQL table. Mentioned below is my profile for quick reference. Looking forward to working on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 10 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$30 AUD w 4 dni
4,9 (145 opinii)
6,5
6,5
Awatar Użytkownika
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You will find the similarity.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$166 AUD w 2 dni
4,7 (40 opinii)
5,9
5,9
Awatar Użytkownika
I have 4 + years of experience in MSBI Technology (SQl Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes,Procedures,cte,temp tables and sub queries . Expert in creating SSIS package, configuration, Deployment and Scheduling and extracting the data from different sources like SharePoint lists, excel files, csv files, Data feed store, MySQL database, sql databases etc. Expert in creating different ssrs reports like drill through, drill down, parameterized, table, matrix,Chart,Line,Stacked columns, Map ,Document type etc. SSRS reports integration with SharePoint and windows applications. Fetching the data from multidimensional cube, tabular cubes with the help of MDX queries and creating SSRS reports. Expert in handling the huge databases (in TB) and performance optimization of the legacy codes.
$25 AUD w 1 dzień
4,8 (29 opinii)
5,1
5,1
Awatar Użytkownika
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$15 AUD w 0 dzień
4,9 (25 opinii)
4,6
4,6
Awatar Użytkownika
Hi. I can create a VBA macro to connect to the Sql database and run direct queries to ad the data (this is the simplest form). A better solution will allow you to also select which columns to update and to provide credentials through a user form (more effort / a higher price).
$35 AUD w 1 dzień
4,9 (26 opinii)
4,2
4,2
Awatar Użytkownika
hi, would be glad to help you with this project. regards, yuri .
$25 AUD w 3 dni
4,9 (27 opinii)
4,2
4,2
Awatar Użytkownika
A proposal has not yet been provided
$30 AUD w 0 dzień
4,8 (13 opinii)
4,3
4,3
Awatar Użytkownika
Hi, I have 8+ years expereince in VBA, and I have did the same kind of work before, as part of my dayjob by running RDBMS connection strings to connect the server and upload the data. Please let me know your comments Regards, Param
$30 AUD w 3 dni
5,0 (2 opinii)
2,0
2,0
Awatar Użytkownika
A proposal has not yet been provided
$20 AUD w 1 dzień
4,8 (7 opinii)
2,3
2,3
Awatar Użytkownika
Hello! We will help you do your job today. We start immediately as soon as you Choose the us. I hope you enjoy our work. Thank you.
$25 AUD w 1 dzień
5,0 (3 opinii)
1,1
1,1
Awatar Użytkownika
1) Create a macro enabled excel file where the VBA procedures are coded. 2) The VBA procedures will be available whenever Excel App is open. 3) The procedure will import the information from a specific file with normalized data and upload to SQL table. Data should have a finite number of columns which shall represent each data set or data column in SQL. The number of rows can be variable. Requirements: SQL Credentials SQL Table Structure
$388 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
if your website bassed on worpress, i could make it faster. My name is Alex and i am a web developer from Ukraine. It is my fisrt work, so i will try my best for good review from a customer. Looking forward to hear from you. Thank you!
$25 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Creat in data from Excel to query insert into and from connect to database insert data to table. write me))
$25 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Sir, This project can be done using a windows application to read the document and upload specifics rows into SQL database. Best regards Mostafa
$40 AUD w 7 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
It can be done using External tables approach in Oracle where a file excel file can be placed at location and accessed in database using external table. Later can be loaded to any staging based on requirement.
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Good day, Sir. I have experience in writing sql queries and VB macros. I have done the same job. I will provide you with excel macro if you give me more info. Yours Sincerely, Vitaliy Lukashev
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Dear Customr, I would write excel formula generating SQL isert statement for each row. Sql generated could be executed in SQL console , osql. Regards
$15 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
i have done it several times already so i only need to adapt it for your needs
$10 AUD w 0 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
1. Project approach : a. You provide me all files b. I provide with completed code c. You revert for any changes, I send updates d. You pay me e. I provide free support for 2 weeks 2. Code approach : a. Read excel data row by row, validate each row, check for current entry, log each row checked b. Connect to MS SQL Server using ADO, update data, log each row added
$25 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
ADELAIDE, Australia
5,0
41
Członek od wrz 5, 2014

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.