Find Jobs
Hire Freelancers

Update online SQL Server from Access

$50-80 USD

Закрито
Опублікований about 10 years ago

$50-80 USD

Оплачується при отриманні
I have a current process which reads an Access table and loads the data into the appropriate row on the Online SQL server database. Maintaining the online SQL Server data for the website involves: (1) MS Access tables containing the prices and layout details for each product category. (2) The business owner maintains the product details within each category (including prices) using his laptop . (3) Replacing the appropriate online SQL Server table prices and product details with the details from the required Access table. One part of this is now failing because the vb code no longer runs. I have developed a process using MS Visual Basic 2010 code which reads the Access table and produces the rows which need to be loaded to the SQL Server database. I do not know how to program the code which does the actual load to the sql server database. What I would like you to do is to produce some code which reads the MS Access table data for the "Royal Mail Smilers" table and exports the data to a SQL Server database table. The website in question is [login to view URL]
ID проекту: 5530880

Про проект

31 пропозицій(-ї)
Дистанційний проект
Активність 10 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
31 фрілансерів(-и) готові виконати цю роботу у середньому за $83 USD
Аватарка користувача
Hello, I am very much interested to do this work as i am experienced a lot working with ms access as well as ms sql server. And i also developed many projects by vb.net, so i think i am the right person to do this work. Looking forward to have a positive response from you. NB: I can do this work by $40 only as this work is easy for me. Thanks
$50 USD за 2 дні(-в)
4,9 (383 відгуки(-ів))
7,8
7,8
Аватарка користувача
We are a team of developers with expertise / experience in Vb.net, MS Access, MS SQL. We have recently written a program / code to connect to MySql database of a web application and print the documents. I have read the requirements and am confident of delivering well. I request you to share: 1. Access database with some sample data 2. SQL database with some sample data 3. Mapping between the two 4. Do we check for duplication when exporting data from Access to SQL database? Or do we allow for filtering data of MS Access based on some fields before the export cod is run? 5. Will the export code be run manually or will it be scheduled? On seeing the above inputs and details, i will be able to assess scope of work precisely. I will revise / confirm my bid accordingly. Detailed specifications will also help me to make an informed commitment and are essential for delivering as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project. You are a very highly rated client with many projects to your credit and I will consider it a privilege to offer my services to you. I look forward to this project as an opportunity to establish a long term association.
$84 USD за 2 дні(-в)
4,9 (108 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hi. I've worked a lot in .NET and with databases (MySQL, MS-SQL, Access etc). I can quickly make a simple program for you which reads the data from local MS-Access database and upload the data to website database. just show me the sample source and destination databases, and any particular requirements. I'll do this within a day or two. I'm very interested in this task and I have the skills to accomplish it for you. let's do it. hope to have a good business with you :) waiting for your response...
$50 USD за 3 дні(-в)
5,0 (78 відгуки(-ів))
6,9
6,9
Аватарка користувача
Hi, This can be achieved by writing Insert Script in application using data read from Access. I have 9 years experience in C#, Win-Forms, ASP.NET/ MVC with Jquery/Ajax and for services using WCF/Rest WCF/Rest Web ApI and SQL Server 2008/R2/2012 for back-end. Thanks
$72 USD за 3 дні(-в)
4,9 (58 відгуки(-ів))
6,9
6,9
Аватарка користувача
I like to discuss further and deliver the project to your specifications and needs .
$84 USD за 3 дні(-в)
4,9 (90 відгуки(-ів))
6,9
6,9
Аватарка користувача
hi, I am interested to develop an application to read access data and write in to appropriate field of MSSQL. I can start the work right now. Please see my previous work and let me start with the job. Thanks Prakash
$60 USD за 2 дні(-в)
5,0 (38 відгуки(-ів))
6,0
6,0
Аватарка користувача
Hi! I am interested in your project. I understand the requirement and ready to work on it. Please accept my bid so that I can start working on it. Regards, Daniel Fabia
$55 USD за 3 дні(-в)
4,9 (120 відгуки(-ів))
5,5
5,5
Аватарка користувача
Hi, I understood your high level requirement. I am interested to work on this project. I have 5+ years experience in software development and customization using wide range of Microsoft technologies (C#, ASP.NET, MVC,WPF, Window form, Sql Databases, Azure, Sync framework etc.) and few open source like PHP,Java,JabbR. Since i have previous experience in such applications, so I think it will help in this project, if selected. About my previous work, you can visit my profile to see feedback from previous employer. Let me know, If you find me suitable for this project and share complete details. If you want more details, we can discuss over chat/ skype. Regards, Shashi Bhushan
$55 USD за 2 дні(-в)
4,9 (27 відгуки(-ів))
5,1
5,1
Аватарка користувача
Hi Timi, I'm very interested helping you updating your SQL Server table from Access, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$80 USD за 3 дні(-в)
4,3 (36 відгуки(-ів))
5,5
5,5
Аватарка користувача
I have developed a number of "adapter" applications in the last 15 years in my role as a integration specialist. I used MSSQL and access as both source and destinations in a number of these deployments. I would assume that the old vb code is still available so the actually transformation would be very clear. If this a "scheduled" task or does the business owner trigger an update. The code would be the same in either case, just the UI necessary might be slightly different. If scheduled task execution is needed then you will need a simple UI to load and save configuration information. I can be reached via skype if you would to discuss the project. Cheers, Brent McCaw
$166 USD за 1 день
4,9 (6 відгуки(-ів))
4,8
4,8
Аватарка користувача
Hello, I have expertise in working with MS SQL Server and MS Access both. I can develop an application in .NET which can work as per your requirements. I have worked on various MSSQL/MS Access projects. This is any easy task for me and I can do this for you in satisfactory manner. Thanks, Nehali
$50 USD за 2 дні(-в)
4,6 (19 відгуки(-ів))
4,8
4,8
Аватарка користувача
I am available right now. In my total 13 IT years of experience I have done lots of with project management.I am a expert Database Architect.I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
$100 USD за 3 дні(-в)
5,0 (7 відгуки(-ів))
4,2
4,2
Аватарка користувача
Hi. I've dealt with exporting MS-Access data into an MSSQL server. Since the part of loading the data from Access is complete I will be able to check if the data exists in SQL. If it does, I will update it with the new values. If it doesn't, I will insert new values into the table (or ignore these rows if you prefer.
$63 USD за 3 дні(-в)
5,0 (4 відгуки(-ів))
3,9
3,9
Аватарка користувача
Hi, An ASP.NET,c#,vb ,SqlServer,JQuery,Javascript expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements... I would like to have a detailed document of your requirements so that we can discuss the each and every point in details. Thanks, Murtaza
$350 USD за 7 дні(-в)
5,0 (8 відгуки(-ів))
4,1
4,1
Аватарка користувача
Hi, I can help you with this import task from Access to SQL Server. What SQL Server version do you have? Thanks in advance!
$55 USD за 3 дні(-в)
5,0 (6 відгуки(-ів))
3,9
3,9
Аватарка користувача
Hello , work is not complicated , I have experience in Visual Basic and C # Application , or by linking tables with SQL Server access regards
$55 USD за 1 день
4,9 (4 відгуки(-ів))
3,8
3,8
Аватарка користувача
Hi, I'm a certified SQL Server Database architect[MCP, MCDBA, MCTS, MCITP] with 11 Years of experience in SQL Server database administration and development, and I'm very interested in your job post involving these skills. Thanks, Ranjith
$72 USD за 3 дні(-в)
5,0 (1 відгук)
2,7
2,7
Аватарка користувача
Hi, I have read the description of your project and I would like to offer my services for this project. Over the last 10 years, i have done many projects on different languages and databases. I can show you my recent work which i did over different freelancing sites. Recently i completed a database of a lawyer firm, which used the software to store their clients and case information from the start to end. It is running in many US lawyer firms successfully. Let me know if you want to know more. Thanks
$72 USD за 3 дні(-в)
5,0 (3 відгуки(-ів))
2,6
2,6
Аватарка користувача
Hi, I am a full time freelancer and an expert in Microsoft Technologies. I have more than 8+ years of extensive experience including Visual Basic + Access + SQL Server. I would like to offer you my services. I am a Microsoft Certified Professional and this would bring your confidence to me. I have been involved in all my projects as programmer and that gives me distinct advantage of a good technical person. Please let me know if we can work together. Looking forward to hear from you.
$250 USD за 5 дні(-в)
5,0 (3 відгуки(-ів))
2,5
2,5
Аватарка користувача
Hello, I work as a database administrator and software developer. I have experience in Java, JavaServer Faces, Eclipse, MSSQL, MySQL, developing web applications, database design, SQL scripting and database administration. I also have some knowledge in Visual Basic, so I think I could easiy adapt myself to your requests. Basically, your problem is with ODBC, so I will check it up and add some prepared statements handling result sets from Access before inserting them into SQL. If you're interested, I will provide you my Skype account so we can contact.
$72 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED KINGDOM
birmingham, United Kingdom
4,8
155
Спосіб оплати верифіковано
На сайті з черв. 27, 2012

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.