I’m trying to prepare a backup file before doing an update, to enable me to go back to the original DATA by comparing to the original file.
The table has a few fields deifined as BIGINT. Saving the DATA to excel is useless, as excell doesn’t save them correctly. I thought that saving the DATA to a CSV file would solve the problem, but lo and behold, the compare to file ( even a CSV) feature uses some MS ACCES tool to read the CSV and does not read the file correctly.
I’ll tro to upload some screen shots.
P.S. I tried this on TOAD vesrion 6.3, 6.5 and BETA 6.6.