Changing Datatype to match two different "Data sets"

Hello Experts,

I have input data from two different packages. One is in CSV format for the year 2015 and another in Xlsx format for the year 2016.

All the columns are matching and I have same columns in each data set. However I am not able Append the data as the "Datatype differs in two data set"
For e.g. Data type for Transaction date in CSV format and Xlsx format do not match.

I am just curious to know if there is any way to identify "Datatype" of each column under two different sets of data and change them accordingly. So that I can append the data without any hassle.

I have attached sample data for your reference.

Your advice/suggestion is much appreciated!

Thanks,
Ganesh
Daily-Booking_2016_sample.xlsx
Booking_2015_COSB_Sample.csv
Ganesh VijaykumarAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

regmigrantCommented:
open the csv and 'save as' an xls format and Excel should be able to manage the types for you.

what are you using to do the append? if its a yearly occurrence Copy/paste is probably the quickest.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tomfarrarCommented:
Part of your problem may be there are two different date formats on the 2015 Booking, one of which is looked at as text.  Sample data from 2015 report below:

21-01-2015
30-09-2014
5/3/2015
22-12-2014
23-02-2015
19-08-2015
7/11/2014
29-07-2015
0
Ganesh VijaykumarAuthor Commented:
Thanks, i was able to resolve this issue.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.