|
QDAC supports the following file formats: - Microsoft Excel (.xls) - Microsoft Word (.doc, .rtf) - Microsoft Access (.mdb) - Comma separated (.csv, .txt, .del) - Dbase (.dbf) - Paradox (.db) - Foxpro (.db) - HTML (.htm, .html, .mhtml) - XML (.xml) - DIF (Data interchage format .dif) - Auditfiles (.adf, .xaf, .xas) - PDF Adobe Acrobat File (.pdf) - Fixed record length - Text files (for instance print files) - Databases via ODBC |
- Multiple MS Access tables can be joined. - Multiple Excel worksheets and workbooks can be joined in 1 table. - You can simultaneously open multiple files into 1 table. - You can join together multile tables into 1 Excel workbook with multiple sheets. - You can define text and numeric fields in binary files. - Various filters can be used to read the data in a structured way. |
|
For reading MS Office files QDAC uses Object Linked Embedding (OLE). The office suit has to be installed to read these files directly. Of course you can use ODBC to read MS Office files when the office suit is not installed. To read Paradox and Foxpro files QDAC uses the Borland Database Engine (BDE). The QDAC setup file includes the BDE. QDAC uses ODBC to open various databases (for example Mysql,Oracle etc.) | |