I gang

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

Færdigheder: 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:

Prashantskin

[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 Mere

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

46 freelancers are bidding on average £125 for this job

svet63

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)
6.6
cheapexcell

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)
6.2
maverick44000

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 Mere

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

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice that I have not Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

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] Mere

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

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 Mere

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

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 Mere

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

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)
4.7
infoshree80

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)
4.7
paris2785

Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my feedback at [url removed, login to view] I can start right away. F Mere

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

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)
4.1
vikas0903

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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