I have a database that creates text files with data generated from the tables in the database.
These textfiles (comma separated, *.txt) are placed on our network where they are picked up by another program. This other program (Oracle database + code in C++) should read the data in the textfile and use it inside the oracle database.
All this worked fine as the textfiles were generated by the former solution (a dbase program).
Since we introduced our Access solution, the textfiles we produce are no longer accepted by the Oracle database. When we compare the textfiels generated by Access to the old ones generated by dbase, we find no differences although we are checking them even up to hexadecimal level.
Nevertheless, the Access textfiles get not accepted.
Anyone could help us on this? What are we overlooking?
(And no, it's not spaces or End-of-File signs...)