I'm importing a text file into Access from a SQL program.
There are three sets of dates (DATE_HIRED, DATE_PROBATION and DATE_PROMOTION). They are all three formated in SQL to read the same format (ex. 01-NOV-95). The first two import into my table but the third date has a conversion type error. I can't figure it out. Why would two dates work but the third not. If I make it a Text file in design view it will import but it won't sort correctly. So I need it to be DATE/ TIME but always get a conversion error on import. I've got till Tuesday to get this to work. I've tried all weekend now. Please help.
There are three sets of dates (DATE_HIRED, DATE_PROBATION and DATE_PROMOTION). They are all three formated in SQL to read the same format (ex. 01-NOV-95). The first two import into my table but the third date has a conversion type error. I can't figure it out. Why would two dates work but the third not. If I make it a Text file in design view it will import but it won't sort correctly. So I need it to be DATE/ TIME but always get a conversion error on import. I've got till Tuesday to get this to work. I've tried all weekend now. Please help.
