Importing DBF file into Oracle
One of my Apex app's requirements is to import files into Oracle. I've been looking at Vikas' example of importing a CSV file into an Oracle table and have got it working with a simple CSV file.
However - does anyone know of a way to import DBF files (DBase III) files using the same or a similar method? The DBF files have some Unicode or Binary data at the beginning which means the Apex app will not read them properly.
DBF files open fine in MS Excel as it can read them with a built in filter - when opening in Excel, they look like CSV files. So our IT department assumed that they were CSV, when in fact they're not.
Converting them manually to CSV is not an option for us. And we can't get them in any other format.
Anyone got any good ideas of how to deal with them?