Đang Thực Hiện

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.

Kỹ năng: Nhập liệu, Microsoft Access

Xem thêm: contact lists microsoft access, microsoft access contact lists, microsoft spreadsheets, excel split columns, data contact list, access microsoft, data contact number, contact access, access clean data, using 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, company address contact number, company name contact number, clean entry excel, split address

Về Bên Thuê:
( 7 nhận xét ) Reading, United Kingdom

Mã Dự Án: #1085136

Đã trao cho:

sinfulm3

Hello Sir, can do this quickly.

£50 GBP trong 1 ngày
(9 Đánh Giá)
3.9

17 freelancer đang chào giá trung bình £80 cho công việc này

rhomeu

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

£100 GBP trong 1 ngày
(42 Đánh Giá)
6.6
YourAssistant

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

£100 GBP trong 2 ngày
(97 Đánh Giá)
6.1
greggfletcher

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

£100 GBP trong 1 ngày
(22 Đánh Giá)
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 Thêm

£150 GBP trong 10 ngày
(14 Đánh Giá)
4.3
shmai

Ready to start!!!

£75 GBP trong 2 ngày
(12 Đánh Giá)
4.0
surajddk

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

£50 GBP trong 1 ngày
(2 Đánh Giá)
2.7
easycoders

Hi, Please check your inbox.

£60 GBP trong 3 ngày
(3 Đánh Giá)
2.3
deepaknegi18

Please Check PMB.

£20 GBP trong 0 ngày
(1 Đánh Giá)
1.0
Umeir

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

£50 GBP trong 1 ngày
(0 Đánh Giá)
0.0
TheTaj

check pmb thanks

£40 GBP trong 1 ngày
(0 Đánh Giá)
0.0
freelancerpinoy

Please check PM

£150 GBP trong 2 ngày
(0 Đánh Giá)
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 Thêm

£100 GBP trong 7 ngày
(0 Đánh Giá)
0.0
powerx

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

£75 GBP trong 5 ngày
(0 Đánh Giá)
0.0
HardikR

please check pm

£70 GBP trong 2 ngày
(0 Đánh Giá)
0.0
nkwpdn

I have can deliver the job in time at desired level

£50 GBP trong 1 ngày
(0 Đánh Giá)
0.0
kamachi2009

Ready to start the work. Please check in PMB.

£120 GBP trong 2 ngày
(0 Đánh Giá)
0.0