Excel to Access

I have a bunch of excel files and I want to combine them into one database in access.

As you can see, there are 3 files below that I want to integrate into microsoft access 2007.

The file 5.2 TEST will have all of the data from 5/1/2012. Inside, you will find several sheets, but the important sheets are Phones and Accessories. In the sheet Phones, you will find a range of table. The blue color indicates incoming phones from supplier that are still in warehouse untested. The green color indicates what phones are left in testing room. The orange color indicates overall phones left. The purple color indicates what phones are being sold today, backdoors packed with the phones. The Accessories sheets contains the number of accessories overall and what are being sold today, and the formula is gotten from the count file. Explanation about the formula: if phone A and phone B are being packed and shipped, the battery and charger and boxes and envelopes are being deducted according to count file.

The file May 1 - new count will have all of the data from the testing room on 5/1/2012. The file contains what phones are currently being tested, pass as new, pass as used, pass as refurbished etc.

The file count will have the information about the item

What I want to do is to create a microsoft access database in which I can monitor the data in 5.2 TEST and May 1 - new and create a report based on what items to order next, how many items to test next.

Compétences : Saisie de Données, Traitement de Données, Excel, Microsoft Access

en voir plus : warehouse data entry, how to find a new microsoft phone, data entry in access 2007, a.b.c. warehouse, microsoft excel test, microsoft access test, how to microsoft excel, excel sheet formula, report from excel, packed, i want to do excel, excel to, Excel to Access, Excel report, excel formula, combine excel, charger, blue room, b blue, b & blue, access microsoft, combine order, excel contains, monitor integrate, excel access table

Concernant l'employeur :
( 0 commentaires ) Inglewood, United States

Nº du projet : #1603979

16 freelance font une offre moyenne de $120 pour ce travail


VBA expert here - More details in PM - Many Thanks - Rajiv

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(90 Commentaires)

I can convert your excel files to Access and create some reports for you. I have 15 years exp in excel and access. Thanks Donna

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(41 Commentaires)

Hello. We are a team of professionals in developing MS Excel/Access +VBA applications. Familiar with report creation. Have a glance at your PMB.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(26 Commentaires)

Hi, I can do it! Cuong NH

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(25 Commentaires)

Hi, I've PM you on my preliminary assessment on this project, which is definitely do-able. Alongside data migration/integration from Excel to Access, my Manufacturing Operation job experience would enable me to build-i Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(20 Commentaires)

This would be no problem. I can get started this evening as I currently don't have any other projects I'm working on. All of my customers have been completely satisfied with my results and I'm confident in guaranteei Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Dear Sir, Please read your PM Thanks Meena

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(12 Commentaires)

Hi I can help on this

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 6 jours
(10 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(1 Évaluation)

More than a dozen projects in MS Access and a [login to view URL] knowledge of Excel and surety of completion of task on time.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

I have ten years experience in Access Databases. I studied your project. I can do this job easily. More details in PMB Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

Hi there, it would be my first freelance job, but I'm doing such data transfer and analitics every day on work (Excel, Access, SQL). See my portfilio! Best Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)

An expert In Access database with nearly 5 yrs of experience.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)

I am very interested in your project. From previos I belive I can make it very useful.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

Hello Sir! I have worked like a programmer assistant for already 5 years. We used always Access for the database. And convert Excel to Access is a practice. I can do well this work for you for your satisfaction and to Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)

I have great experience of automations and working knowledge of MS-Excel and Access. I have 6 yrs exp.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)