wow, this is messed up, I can't post in the regular mode. Oh well,
My questioin is: I have flatfiles from DBMan that I need to import into SQL tables for (DBManSQL)
However, my date fields in DBMan are formated as:
MMM-DD-YYYY (ex: Jun-19-2003)
and I would to use a date or datetime field in the SQL version rather than a text field.
Is there a way to translate all these dates before I upload the files and convert them into the SQL versoin?
Also, I'm already converting the pipes (|) into tabs with Editpad Pro text editor so if there's a way to do this in excel? or something that would be ok with me.
Lynette
Hollister, Ca
Lynette
Hollister, Ca