ahh, that makes sense, not sure how I didn't notice that...I am not sure what time that is suppose to be so I will just exclude those for now...thanks for...

One more question...anything from 1065-1095 I am getting error The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

All other values work...

nice, thank you!

Nothing on the import...It doesn't matter if its marked AM or PM after the convert, just as long as those times are in there.

thanks for the replies, I have not looked into creating a table yet. The code I am using right now is working smoothly, so I wasn't sure if there...