Create Access DB from Excel (Master D)

Stängt Publicerat Apr 15, 2015 Betalades vid leverans
Stängt Betalades vid leverans

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

Databasprogrammering Microsoft Access MySQL PHP Programvaruarkitektur

Projekt-id: #7492533

About the project

78 offerter Distansprojekt Aktivt May 22, 2015

78 frilansare har lagt bud på i genomsnitt $383 för det här jobbet

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 Mer

$421 USD inom 10 dagar
(309 omdömen)
8.8
ParisPallas

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Mer

$250 USD inom 10 dagar
(385 omdömen)
8.2
hwanghendra

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

$368 USD inom 7 dagar
(496 omdömen)
7.5
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 Mer

$250 USD inom 3 dagar
(216 omdömen)
7.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 Mer

$631 USD inom 15 dagar
(134 omdömen)
7.6
PigtailXL

Hi Sr. I'm interested to help you to construct this Access database, migrating the existent data (excel source). I've experience doing this. Would be great to discuss in detail with you how is the source file str Mer

$333 USD inom 15 dagar
(146 omdömen)
7.3
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 Mer

$700 USD inom 20 dagar
(245 omdömen)
7.2
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 Mer

$277 USD inom 7 dagar
(243 omdömen)
7.3
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 Mer

$280 USD inom 10 dagar
(160 omdömen)
7.0
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 Mer

$793 USD inom 15 dagar
(55 omdömen)
7.1
v2x5111

A proposal has not yet been provided

$888 USD inom 10 dagar
(162 omdömen)
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 Mer

$250 USD inom 10 dagar
(120 omdömen)
7.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 Mer

$250 USD inom 7 dagar
(178 omdömen)
6.4
dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to build MS access database from your existing excel worksheet. I have been built many MS Access databases fr Mer

$277 USD inom 10 dagar
(75 omdömen)
6.1
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 Mer

$250 USD inom 10 dagar
(179 omdömen)
6.4
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 inom 10 dagar
(122 omdömen)
6.0
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 inom 10 dagar
(73 omdömen)
6.0
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 Mer

$300 USD inom 3 dagar
(10 omdömen)
5.4
girofreelancer

I am a Microsoft Partner and software developer since over 20 years with extensive experience in office automation, Data analisys, Data Forecasting, etc. (see my portfolio on Freelancer). Based on my long experience M Mer

$500 USD inom 15 dagar
(6 omdömen)
5.4
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 inom 8 dagar
(12 omdömen)
5.6