En cours

Upload contact lists into MS Access

The task is to take a number of excel spreadsheets containing contact list records and upload them into Microsoft Access.

The contact lists have different columns. All columns need to be uploaded. But not duplicated - we only want one column for email address, one for company etc. Where there are new data columns they need to be added.

Some of the records have Firstname and Lastname in one field - these will have to be split out into two fields. Although all data columns/fields are to be uploaded there are 15 main columns/fields.

The bigger record files 3 or 4 of them with 1k to 9k records are clean and can be immediately uploaded with no effort at all. The smaller files with 20 to a couple of hundred or more records are the ones where the name needs to be split into two columns (which can be done using conditional statements).

Once all loaded we would ask you to sort them by first and last name, email address, company to identify duplicates and flag them. If you know Microsoft Access this project is straightforward. If you have any questions please ask.

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

Voir plus : data entry in ms access , contact at once, contact lists microsoft access, microsoft access contact lists, microsoft spreadsheets, excel split columns, ms access email, data contact list, access microsoft, data contact number, contact access, access clean data, using access, contact list using microsoft access, company name contact address, contact number data company, data entry email lists, contact records, clean access project, excel access project, excel clean data entry, project using access excel, conditional fields, project excel access, sort excel email duplicates

Concernant l'employeur :
( 7 commentaires ) Reading, United Kingdom

N° du projet : #1085136

Décerné à :

sinfulm3

Hello Sir, can do this quickly.

50 £ GBP en 1 jour
(9 Commentaires)
3.9

17 freelance font une offre moyenne de £80 pour ce travail

rhomeu

Advanced MS Access developer here. I can help you the data migration. Please check private message box.

100 £ GBP en 1 jour
(42 Commentaires)
6.6
YourAssistant

{{(((Please read PM for further details)))}} …Thanks

100 £ GBP en 2 jours
(97 Commentaires)
6.1
greggfletcher

Hello, i can help you with this project. Please provide me with some of the files. Thanks.

100 £ GBP en 1 jour
(22 Commentaires)
5.6
mindware97

I have read and understood your project requirement clearly. I am a qualified professionals with few years of experience in Data entry, web design & development, Graphic design and Animation. So far, I have finished mo Plus

150 £ GBP en 10 jours
(14 Commentaires)
4.3
shmai

Ready to start!!!

75 £ GBP en 2 jours
(12 Commentaires)
4.0
surajddk

Hi, Let's tart the Project! Check PMB Please!!

50 £ GBP en 1 jour
(2 Commentaires)
2.7
easycoders

Hi, Please check your inbox.

60 £ GBP en 3 jours
(3 Commentaires)
2.3
deepaknegi18

Please Check PMB.

20 £ GBP en 0 jours
(1 Commentaire)
1.0
Umeir

Hello sir I can work on this task please have a look on my PM. Thanks

50 £ GBP en 1 jour
(0 Commentaires)
0.0
TheTaj

check pmb thanks

40 £ GBP en 1 jour
(0 Commentaires)
0.0
freelancerpinoy

Please check PM

150 £ GBP en 2 jours
(0 Commentaires)
0.0
rvdeunida

Good Day! I would like to apply for the Web Data Research & Data Entry (Upload contact lists into MS Access) position in your company. I have been working in a call center (UK based, 118118, The Number) as a Customer S Plus

100 £ GBP en 7 jours
(0 Commentaires)
0.0
powerx

hello, how are you ,iam ready to do the job for you .

75 £ GBP en 5 jours
(0 Commentaires)
0.0
HardikR

please check pm

70 £ GBP en 2 jours
(0 Commentaires)
0.0
nkwpdn

I have can deliver the job in time at desired level

50 £ GBP en 1 jour
(0 Commentaires)
0.0
kamachi2009

Ready to start the work. Please check in PMB.

120 £ GBP en 2 jours
(0 Commentaires)
0.0