Unanswered: Trying to create a DTS package to import dbf tables & need help
I am trying to create a DTS package that will import dbf tables. My problem is that the data was created back in the pre-dos 5 days, so to save room they took the dates and convert them to 2 characters.
Now I would like to import these tables and conver the date back. I do have a Function that I can run in FoxPro to "Unpack" these dates.
Function UnPackDate( cDate )
*!* PARAMETERS: f_datestr - Character (manditory). This should be a two
**!* byte string created with PACKDATE().
*!* RETURNS: A date from 1/1/1970 and 11/29/2126
well that is my fault. i should have specified that the format is old, but the actual data is needed. the program is an actually written in clipper.
I have never had to do this before. It is an interim solution. I can schedule it run after hours. So you are saying that I can just copy the Function Unpack Date into the transformation portion of my import?