In Progress

MS access multiple .xls to access converstion

Project: [url removed, login to view] Convestion to Access Database

Purpose: To convert [url removed, login to view] to Access Database, for better integration with PAI perpetual inventory.

Notes: [url removed, login to view] file is located in a shared folder on Guida’s network.

Current State: The data in milkman originates from the [url removed, login to view] file. The plant order file is on Ray’s computer, he prints out a report after keying in the production numbers. The production numbers are based on current inventory (keyed in by warehouse). This report is transferred to the Computer Room. In the computer room it’s keyed into the [url removed, login to view] file, a report is printed and given to production department. Production planning is based on the report generated from milkman.

Future State:

Primary Goal: To convert [url removed, login to view] into an access based database, this will be shared amongst individuals throughout the company. This new database will be hosted on a network server and will be viewed/edited throughout the day. The database will generate a report at the end of the day containing “production orders”; which are then fed into the PAI inventory database.

Secondary Goal: We would also like to convert the Plant [url removed, login to view] file into a database file. This file contains historical data, which is used for production estimates. We would like the last two years of data to be imported into the new database.

notes:

There are over close to 400 UPCs currently being produced at Guida’s

There will be multiple users, different departments with different access.

Example: Production department will only need read access to a list of reports.

Example: Inventory manager will key in the requirement.

Skills: Excel, Microsoft Access

See more: plant manager, file converstion, example inventory database, xls, warehouse inventory, state room, shared folder, production planning, pai, ms s, milkman, hosted network, departments, convert access reports, access microsoft, access manager, data integration excel, generate reports excel, excel convert access, convert reports database, example planning report, multiple excel, multiple warehouse, access order, computer folder

About the Employer:
( 0 reviews ) New Britain, United States

Project ID: #1243449

Awarded to:

iosifrn

Hello, I have over 15 years of programming experience in MS Access, VBA, Excel, Web Development, ASP.NET, SQL Server, ORACLE, C#, Visual Basic and others. I worked for companies like SIKORSKY, GE Aircraft Engines, UMA More

$12 USD / hour
(1 Review)
1.0

20 freelancers are bidding on average $12/hour for this job

kulhanekd

I would love to assist in this project. How many hours do you expect it to take? I have 15 years experiance in access development. Thanks Donna

$13 USD / hour
(41 Reviews)
5.9
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$8 USD / hour
(18 Reviews)
4.5
tamrakar81

Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Please check PM . Thanks, TTS Team

$8 USD / hour
(15 Reviews)
4.4
ExactSystems

Please see bid detail on PMB. regards

$15 USD / hour
(4 Reviews)
4.5
fernandors87

Hello sir. I am an experienced developer of Access databases. I worked on the production planning department of a local company and I understand exactly what you need. I can develop this project in Access with a very p More

$10 USD / hour
(5 Reviews)
3.9
muthumuni

Hi, Well experienced developer here. So kindly have an interview and select me after evaluation. Thank you in advance. Your satisfaction is my success muthumuni

$8 USD / hour
(7 Reviews)
3.6
guevanjr

Please consider my bid. Thanks

$8 USD / hour
(7 Reviews)
3.3
gerrymwalsh

Hi, I am a full time freelancer, with 20 years ms access development experience. I can provide the system you require. Regards, Gerry

$14 USD / hour
(1 Review)
2.4
proitagent

Hi there, I am a ms access guru and am absolutely sure I can help you in this. REgards

$20 USD / hour
(1 Review)
1.7
DamithaKD

Hi, I am a Programmer for 7 years. i can make a Program to convet the xls to Acess. if you interested tel me :) Kaushalya Damitha

$8 USD / hour
(2 Reviews)
1.6
LeedsITSolutions

Project Proposal We would provide a multi-user system as described in the attached document. It would take about 2 weeks to deliver the system for your testing. Which version of Access do you use?

$12 USD / hour
(1 Review)
1.0
chaudharypc123

I am complete your project in time so please give me this job.

$12 USD / hour
(0 Reviews)
0.0
alfelectronics

Good day your way. I have read your requirements and believe I can make you the perfect database. Automation is the key to improve the islanded information inherent to most of today's manufacturers. Thank you in adv More

$20 USD / hour
(0 Reviews)
0.0
uniquereza

~Belive In the Best Service in Business~ Please Check PM.

$8 USD / hour
(0 Reviews)
0.0
cent040

I will complete your work in time Sir. don't worry

$10 USD / hour
(0 Reviews)
0.0
vdvadher

I am working with this type of project in Deaprtment of POst : india Please give me chance to serve you i have 12 years of experience in this field.

$8 USD / hour
(0 Reviews)
0.0
Rakeshkmrsharma

Hi, I can do this project better than others. I am working as Analyst. I am expert in datamining, conversion and development. Expert in excel/access/vba/vb6. I assure you 100% quality within given timelines. Thanks More

$8 USD / hour
(0 Reviews)
1.9
nelson1812002

I have over 28 years' as a technical writer, developer, and CIO. I have created complex, menu-driven MS Access apps for large clients like AT&T, Cox Communications, shipping companies, and others. I would like to b More

$15 USD / hour
(0 Reviews)
0.0
tomb242

I have over 15 years experience of developing, enhancing, maintaining and administering access databases. Many of these have been created from excel spreadsheets.

$15 USD / hour
(0 Reviews)
0.0