Access Database Creation from Excel Spreadsheet
Project ID:
580955Project Type:
FixedBudget:
$30-$250 USD
Project Description:
I have an excel spreadsheet with US Census data for approximately 900 metropolitan areas, and I need the information converted to a Microsoft Access Database. The spreadsheet is attached.The spreadsheet has the city information as columns instead of rows, and each contain several datasets. For example, each city has datasets, labeled in the lighter green, covering numerous topics such as populations and employment data.
This data will be used later on to link with a variety of content, to link content with a variety of information on different geographic regions.
I need an Access DB that can house this information. The main tables will be to establish structure, and provide the linking functionality.
A table to the States, a two column table with the proper name and the two letter abbreviation.
A table of cities, located in the dark green, at the top of the excel document. This table will include the city name, the state, and the Census classification. There will also be three optional fields for “subcities.” There are a few city areas that will have two states selected, these cities will need to come up under searches for both states.
I will be importing lots of data, and I need some tables to manage how everything links up. For example, some sites might list San Francisco as San Fran., San Francisco Bay, SF, etc., and we need some tables to manage that.
I need a table for the alternative names for the states to add in variations, so all of the records will match up under state regardless of source.
I need a cities table with the same purpose.
Each of the variations tables needs to allow links to multiple selections, so several entries could be created under “Southern Califonia” for example, so that record would link to all of the cities.
I need data tables created as well. The datatables are included in the document and colored light green. I need a table created for each one of the headings (Basic Variables, Age: Total, etc.). The tables need to include the city and state, and have them linked to the appropriate master table.
Finally, I need a query set up to identify any records that are not linked to a city or state.
I am looking for someone that can get started quickly.
Skills required:
Excel, Microsoft AccessAdditional Files:
Sample.xlsxPublic Clarification Board
4 messages
-
RandyKrupa
Greetings:
I have been looking for Microsoft Office positions that I can do from my home office. I noticed that you posted an 'Access Database Creation From Excel Spreadsheet position', position number (580955), on Freelancers that matches my skill set.
The data in your spreadsheet can be converted to an Access database, although not with a wizard converter. The converter would have to be created to read the spreadsheet in. Either that or I would write a macro that swapped the columns with the rows and then use the wizard. Either way there will be some custom importing to accommodate things like the subcities. I have a table that has the US Zip codes which I might incorporate to help import cities like San Francisco along with cross-reference tables. If you can get them classified, I like your idea of the "subcities" for searches like Southern California, etc.
I'm assuming that you are either getting your percentages directly or you are calculating the percentages - I can accommodate either way. I would like to work with you on this project. I can start it on the 4th of January and expect it to take about 1 week to deliver a working package.
I am a US Citizen and English is my first language. I live in the Eastern Time Zone (GMT-05). I look forward to hearing from you!
Thank You,
Randy Krupaover 2 years ago
-
najib0s
Hello,
I'm an experienced freelance programmer , just check my profile on SL :
https://www.scriptlance.com/cgi-bin/freelancers/feedback.cgi?p=najib0s
Regards,
Najib.over 2 years ago
Awarded Bids
All Bids ()
HussienSharaf
|
HussienSharaf
From Egypt
Gold Member
Offline
|
Freelancer Orientation (85%, 99th percentile)
Foundation EUFreelance.com Member
$180
in 4 days
over 2 years ago
hi,
i m the best DB expert. I will provide u a very dynamic tables structure and friendly GUI
Hussien Sharaf
lucky2gaf
|
lucky2gaf
From Bangladesh
Offline
|
Foundation Freelancer.co.uk Member
Freelancer Orientation (75%, 94th percentile)
Employer Orientation (75%, 97th percentile)
General Freelancer Orientation (90%, 98th percentile)
Foundation LimeExchange Member
$200
in 4 days
over 2 years ago
Hi, please view my PM, thanks.
dev3dworx
|
dev3dworx
From Pakistan
Gold Member
Online
|
General Freelancer Orientation (80%, 90th percentile)
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$135
in 7 days
over 2 years ago
At your service. Kindly check PMB for details.
DBguy
|
DBguy
From United States
Offline
|
US English Level 1 (98%, 88th percentile)
SQL Level 1 (90%, 85th percentile)
General Freelancer Orientation (95%, 100th percentile)
$100
in 2 days
over 2 years ago
Good Evening, Please check your PMB. Thank you for the consideration. Best Regards.
I am Ms-Access expert developer. I have very good experience with Ms-Access 2000/2003/2007. I have completed many projects on GAF in Ms-Access & Excel skill. I will provide quick & professional service.
KellogITSolution
|
KellogITSolution
From India
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
Hello
Ready to start right now. Please see your PMB for details.
Thanks
syslogic
|
syslogic
From Germany
Gold Member
Offline
|
WordPress (78%, 82nd percentile)
General Freelancer Orientation (85%, 95th percentile)
Foundation EUFreelance.com Member
$200
in 14 days
over 2 years ago
please see the PMB
Hi Sir,
Please allow me to take this project.
Please check my PM for more details.
Regards
Varun Sharma
asaikiran1979
|
|
asaikiran1979
From India
Offline
|
Foundation Freelancer.co.uk Member
US English Level 1 (95%, 71st percentile)
General Freelancer Orientation (100%, 100th percentile)
Foundation EUFreelance.com Member
$50
in 1 day
over 2 years ago
Ready here...! Expert..Let's Start.....!
neelu7779
|
neelu7779
From India
Offline
|
Foundation Freelancer.co.uk Member
$30
in 2 days
over 2 years ago
hi,
My bid is less than 30 but I can not enter 30 in the amount. So I can do one more job for you...in same project
snuwanlk
|
snuwanlk
From Sri Lanka
Online
|
US English Level 1 (88%, 36th percentile)
General Freelancer Orientation (90%, 98th percentile)
$100
in 5 days
over 2 years ago
Hi There,
I am good in MS Access. I can complete you the project. I have worked on Access 2000, 2003 and 2007 as well, with a software development background. I can get the database developed with the way you want..... more
Hi There,
I am good in MS Access. I can complete you the project. I have worked on Access 2000, 2003 and 2007 as well, with a software development background. I can get the database developed with the way you want...Can start immediately. less
i can do it, please see my pm
balabeena
|
|
balabeena
From United Arab Emirates
Offline
|
Foundation Freelancer.co.uk Member
Foundation EUFreelance.com Member
$30
in 2 days
over 2 years ago
I would like to take up the project
osky2009
|
|
osky2009
From Philippines
Offline
|
Foundation EUFreelance.com Member
$200
in 15 days
over 2 years ago
I am currently available to start on your project. Please refer to my PM. Thank you
Ok.
The FrontEnd is Microsoft Excell, and the DB MSAccess.
Greetings! Please see my entry on the Project Clarification Board. Thanks, Randy
I have been doing this for 10 years. I can turn it around fast and accurate. I'm reliable and experience. It's very important to setup the table structure correctly to ease the future maintenance issues.
i have worked on several projects on excel to access so i am interested working in this project.please.
It will be my pleasure to have this project
sachindrasangal
|
|
sachindrasangal
From India
Offline
|
Foundation LimeExchange Member
$200
in 15 days
over 2 years ago
have done several projects in access, will get it done to ur specifications!
srikanth1234
|
|
srikanth1234
From India
Offline
|
Foundation EUFreelance.com Member
$91
in 3 days
over 2 years ago
Respected Sir,
With reference to the your website I am Ready to do the online work Sir I am having computer with Broad Band Internet connection I have completed Diploma in computer Science and Engineeri... more
Respected Sir,
With reference to the your website I am Ready to do the online work Sir I am having computer with Broad Band Internet connection I have completed Diploma in computer Science and Engineering and I am Shortly complete my B.Tech so I am having the full Knowledge of M.S. Office software. So I requesting you I will complete your work within given time period
Thanking you sir
Yours Sincerely
less
team of tqm professionals can do it timely.let us work for future
I am a professional who works extensively with various databases and can handle this project easily.
Regards,
Raja Abhishek
Have a nice day and hapy new hear 2010
najib0s
|
|
najib0s
From France
Offline
|
Freelancer Orientation (80%, 97th percentile)
Employer Orientation (75%, 97th percentile)
General Freelancer Orientation (75%, 81st percentile)
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$30
in 0 days
over 2 years ago
It can be done with very high quality of work.
refer to PM.
Hi! Kindly check my PM. I am professional and has people that are trained very well to do projects exactly what you want.
Hello Sir ,
We gone through Your requirment, We are a software development company in new delhi.. and we want to develope this software for u
igatetechno
|
|
igatetechno
From India
Offline
|
Foundation EUFreelance.com Member
$60
in 25 days
over 2 years ago
i will complete the project within 25 days for 60 US $
Respected Sir,
I can do this work very easily so please give me a chance for prove to me.
rani55555
|
|
rani55555
From India
Offline
|
Foundation EUFreelance.com Member
$30
in 2 days
over 2 years ago
I CAN SIR, IF YOU ALLOW ME TO DO. I HAVE WELL EXPERIENCE IN DATA MINING ,MAINTAINING AND DELOPMENT OF DATABASES FOR YEARS. I HAVE ALSO 4 LEADING WEBSITE OF MY OWN.NOW YOU CAN DECIDE.
My advice for you is php/mysql is best combination for you. And it is help ful you to for webpages. If you want then contact me
ShubhabrataKarma
|
|
ShubhabrataKarma
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
Foundation TycoonTalk.Freelancer.com Member
$150
in 4 days
over 2 years ago
I am confident of doing your project.