Data exports

[Guest]

I've set up a database that calculates dates based on user input and then
exports this data along with an ID # to a comma delimited file. The comma
delimited file is then read into another program. This all worked just grand
for a couple of years and then suddenly stopped working. I don't know what
caused the change however I did find the change. When I set the export up
initially the CVS file contained three columns of data; ID#, date 1 and
date2. The ID column was a whole number and the date columns carried the
format of mmddyy. Now when the export occurs it carries out the ID# along
with 2 decimal places and the dates are carried out with the mmddyyyy
00:00:00 format. Bottom line is that the program importing the data cannot
handle decimal points or date data with long year and minutes. I've tried
several times to redo the xport parameters and export specifications but with
no luck. Even the example shows me the data in the format I want but when the
export actuall occurrs it's in the wrong format.
Anyone seen this? Any ideas would be appreciated!

Thanks!

 

[Guest]

I will guess that attempting to fix it at the export stage may be a bit too
far along in the data's existence.....and that you might want to go back to
the table itself and have the change made there....but be careful as there
could be good reason for why the format is the way it is and you could affect
other processes....

Make a duplicate of the table containing the data ....and experiment...

One can manipulate/trim the syntax/layout of info in a field via a
query...to make it suitable for export.......but before going down that path
you probably want to explore the fundamental properties of those fields in
the table itself.... especially if it was just a version upgrade that cause
this and if you control those tables you should be able to change back their
field properties without problem.....

just a guess though....