MS Excel to MS Access Database import Automation

I have an Excel spreadsheet that is updated regularly, that I need to import into an existing database table with the press of a button.

About the Spreadsheet:

- The spreadsheet layout, structure, columns and tabs are static. It's generated with new data from another product.

- The spreadsheet name may be different because it date time stamps the file name when generated.

About the Database:

- There is a single table that needs to be updated.

- The schema of the table is not exactly the same as spreadsheet (e.g. the Name column in the spreadsheet is "hostname" in the database table)

- The schema of the table is however static.

How I imagined it to work is:

There would be a button in the access form to update the table from the spreadsheet.

The excel spreadsheet would be in a predefined location on the file system, like c:\temp\import.

The logic would search a specific column in the updated excel spreadsheet for a unique identifier, such as the name, it would then update the table record with anything in the excel row that has changed, compared to the table data. Sort of like vLookup in excel.

Any new rows in the spreadsheet would be added to the table.

Any rows in the spreadsheet that have been deleted would be marked as deleted in the database table (a Deleted field would switch from No to Yes).

Evner: Excel, Microsoft Access, VB.NET

Se mere: schema update, i need an access database, how to work with vb net, data structure sort, vlookup table, vb in excel, work on ms excel, Vlookup, vb excel, MS Access Database, excel vlookup, excel to, Excel to Access, form update excel, excel sort date, excel update net, excel access table, net excel import, excel row column, excel data automation, update form access, excel unique, sort excel date, net import excel, import data excel spreadsheet access table

Om arbejdsgiveren:
( 4 bedømmelser ) Reading, United Kingdom

Projekt ID: #6047567

Tildelt til:


[url removed, login to view] I have gone through your project requirements. I will develop Access application to automate the import of data from excel to access table. There will be a button in the access form to update the table Flere

£111 GBP in 3 dage
(476 bedømmelser)

46 freelancers are bidding on average £125 for this job


The logic you describe might make the data import somewhat slow but as I see it, there's nothing to do about it. Can do. Regards, Svet.

£120 GBP in 3 dage
(58 bedømmelser)

Hello Sir, I am an expert in VB.NET & Access with over 10 years of experience. I have done many similar jobs. Ready to start. Thanks, Alex

£110 GBP in 3 dage
(78 bedømmelser)

Hi there. I am Usman and I have previously worked on importing data from Excel to Access and vice versa. I am quite clear about your project requirement. Kindly share the Excel sheet and Access DB file so I may have a Flere

£200 GBP in 2 dage
(41 bedømmelser)

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not Flere

£66 GBP på 1 dag
(110 bedømmelser)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

£168 GBP in 2 dage
(59 bedømmelser)

Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification wit Flere

£200 GBP in 3 dage
(23 bedømmelser)

Hi, I can do this in MS Access as well VB.Net. Please let me know if you have any specific preference. Mentioned below is my brief profile Let me introduce myself as an expert in MS Access programming. I have Flere

£50 GBP in 3 dage
(58 bedømmelser)

I'm an expert Access / Excel developer and have done similar data sync jobs in the past. I can do this job for you, delivering a Windows application that will perform the sync from Excel to Access. Good quality, rel Flere

£30 GBP in 2 dage
(23 bedømmelser)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

£150 GBP in 5 dage
(37 bedømmelser)

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] Flere

£263 GBP in 5 dage
(7 bedømmelser)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database Flere

£157 GBP in 5 dage
(8 bedømmelser)

Good day! I am very pleased to submit my bid for your project. ( A ) PROPOSED SOLUTION: MS Access database with functionality as follows: Mapping of spreadsheet columns to database table fields e.g Name=>hostna Flere

£120 GBP in 2 dage
(5 bedømmelser)

i am very good in MS access and MS Excel vba i know macro coding to a very good level willing to work with you on this project Regards

£222 GBP in 5 dage
(51 bedømmelser)

Hello, Having more than 12+ years of experience in development. Done this type of work before. I can show you demo as well on team viewer Looking forward to hearing from you. Thanks Chetnaa Desai

£64 GBP in 3 dage
(15 bedømmelser)

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. F Flere

£129 GBP in 5 dage
(26 bedømmelser)

hi, I am interested to develop an automated desktop application to transfer data automatically from excel to access. Please see my previous work in my profile and let me start with the job. Thanks Prakash

£95 GBP in 3 dage
(11 bedømmelser)

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc Flere

£52 GBP in 2 dage
(7 bedømmelser)

Hi, I am an expert in Excel and MS Access Database. Please review my profile and the projects that I have done in freelancer. I have gone through your requirement in detail and I will be able to create the macro/pro Flere

£166 GBP in 5 dage
(27 bedømmelser)

Hi, I think your project is quite simple and I really can't understand why some other people have placed high bids. What I suggest, is to use a small external application developed in Visual Basic or C# that will allow Flere

£50 GBP in 5 dage
(6 bedømmelser)

Hi, I am interested in this project. I can do the job for you. I have experience of doing this import thing in between MS-Access and MS-Excel. If interested in hiring me then please let me know so that we can discuss Flere

£55 GBP in 3 dage
(11 bedømmelser)