Create Access DB from Excel (Master D)

Closed Posted Apr 15, 2015 Paid on delivery
Closed Paid on delivery

Hi,

I have an excel worksheet that we are using to track our campaigns, we run digital campaign for clients. So each campaign is one line in the excel sheet.

There are currently 6500 row of data - which is slowing down excel and making the sheet very large and prone to errors.

There are about 70 columns - each contains an element of data - such as ID, budget, start date, end date, spend by month etc

I am looking to have this sheet added to an MS Access DB. I ma open to using other DBs - but please let me know if you think this is required.

I then want a form created that will help users to add all the required information into the sheet - it will be a simple form - that allows a user to enter all the new campaign details.

Once the DB is built and complete - I will need a bunch of reports and queries created but that will be a new project that we can agree a fee for.

In addition - as part of any DB of this size there will be some data clean-up required. So make sure you include some time for that.

Any questions please ask.

Thanks

Database Programming Microsoft Access MySQL PHP Software Architecture

Project ID: #7492533

About the project

79 proposals Remote project Active May 22, 2015

79 freelancers are bidding on average $381 for this job

thetechie13

Hi, we will provide you with a webform ( PHP + mysql based ) so that you can add /edit/delete contents of the forms without touching the actual database. Can you please advise if you can provide linux hosting for More

$421 USD in 10 days
(94 Reviews)
7.5
hwanghendra

Hi Sir/Madam. Ready to start. Thanks ..............................................................................................

$368 USD in 7 days
(436 Reviews)
6.9
shikhamehta

Hey, Since your data is already in Excel, Access is the most logical choice to import this data and manage all the future data. We could simply create the database structure similar to your existing file and do some More

$277 USD in 7 days
(215 Reviews)
6.9
natgeo

Hello, I would propose a Mysql database for you and the solution to be web based, with front end coded in PHP. This would enable tje application to be accessible from anywhere in the world. Also, since you want report More

$250 USD in 10 days
(112 Reviews)
7.0
torajiv

Hello I am an exclusive MS Access developer completely dedicated to this platform - I do not work on any other database. I am also among the top three MS Access developers on this site. You can verify by go More

$280 USD in 10 days
(123 Reviews)
6.6
sunsoftpro

Hi Employer, I have read your description and been interested in your project. Please give me more details of your excel file and the relations between columns and sheets. I'm ready to discuss and start to work on it More

$631 USD in 15 days
(77 Reviews)
6.2
vnb400sl

Dear Sir i can develop the MS Access database based on the Excel worksheets and add forms, reports and queries as needed. Data from excel will be imported into the database Warm Regards vnb400

$250 USD in 10 days
(118 Reviews)
5.9
prashushinde9

========Please Don't award this project to us without discussing this project in detail============ Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years i More

$793 USD in 15 days
(27 Reviews)
6.0
expertcoder1vw

Hi, I'm an expert VB / Excel / Access / database programmer and can do the job for you. I can develop a new database with user interface and the needed functionality and logic to make the database work as you need. Th More

$450 USD in 8 days
(63 Reviews)
6.1
alekscoder

Hi, I can create tables to hold information of mentioned by you Worksheet in MS Access database. Users will be able to edit above information in multipage form or common form, if it will be possible with includ More

$250 USD in 7 days
(170 Reviews)
5.6
MarlinSoftware

Hi, thank you for your specification. 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 produce More

$600 USD in 10 days
(24 Reviews)
5.6
mdkass

Hello, I can do this project on Access, or use Access as a back-end database and design the user interface on Delphi, this will give you more capabilities to develop the application in the future. Regards

$263 USD in 10 days
(56 Reviews)
5.6
webiglobe

Dear Sir, I am really interested to work on this project . I have very good experience of doing this sort of job, I can start the work now and can assure the best service from my end. Though you have added a real More

$700 USD in 20 days
(36 Reviews)
5.2
mail2vimalarora

Hi, I have gone through your project details and would like to work on it. I have worked on several such projects which involved transformation of database from excel to MS Access. I have worked on several projects on More

$250 USD in 10 days
(67 Reviews)
5.6
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b More

$300 USD in 3 days
(6 Reviews)
5.1
havit

Dear Client, I am interested build your entry form and table on MS-Access 2013. Please send me the current Excel file format for review. Thank you. Regards, Havit

$555 USD in 8 days
(6 Reviews)
5.1
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More

$366 USD in 5 days
(38 Reviews)
5.5
MDavidCrompton

You have attracted some real talent, I am not used to being 15th. I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance More

$500 USD in 30 days
(14 Reviews)
5.2
acronymsolutions

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Ms Access,Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configuration More

$526 USD in 10 days
(42 Reviews)
5.8
Systems3000

Hi, Access is perfect for your requirements. I have extensive experience in Access (and Excel) within the investment banking industry and I also have two postgraduate qualifications so your project will be straightforw More

$250 USD in 3 days
(21 Reviews)
4.9