Link to home
Start Free TrialLog in
Avatar of PeterBaileyUk
PeterBaileyUk

asked on

importing and changing datatype in import wizard sql server

I am trying to get the correct datatypes into sql server from an access mdb. they have expressed a year as a string. so "1995" and so on, is there a way that can get imported and become a datetype od date or do I have to create a new column and go "01/01/1995"
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PeterBaileyUk
PeterBaileyUk

ASKER

thank you. This follows on from your observation about data types being all over the place which they are.
Great. You're cleaning the house ;)
Good luck with that.