Convert from Excel to Access


i have an excel file that contain nearly 10-11 sheets. Every sheet have same structure of data.

First field contains mobile number ( 10 digit numeric), second field contains name of shop to whom that number is issued (text) and third field contains date of issue ( date)

There are 10-11 sheets because every sheet has a limit of 65500 records.

So i want to combine all these nearly 6 lakh records in a single table in access. U can do it by either importing or by any other way as u ike.

The problem is that in some sheets mobile number is recognised as text instead of number so it is not iported. somewhere date is not in proper format...

So u have to clean the data and create a single MS access table for entire


Time limit is 4 days as this is my academic project

A sample file is attached

## Deliverables

A sample file is attached

Habilidades: Varios, Reescritura de artículos, Entrada de datos, Redacción de investigaciones, Traducción, Asistente virtual

Ver más: structure of an academic text, data structure problem, excel to, Excel to Access, convert mobile, combine excel, excel convert access, excel contains, excel access table, excel digit, create file table access, excel file convert, access clean data, create sheets data sheet, Excel Time sheet, excel sample file, excel combine, clean access project, excel access project, time sheets excel, excel clean data entry, text table excel, convert text time, project excel access, clean entry excel

Información del empleador:
( 1 comentario ) fatehabad, India

Nº del proyecto: #3067300