Friends
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
data.
Time limit is 4 days as this is my academic project
A sample file is attached
## Deliverables
A sample file is attached