You can use Import WIzard (not IMPORT command) to analyze file and build table with matching layout. After that you can use APPEND FROM command to convert files as you've table layout already.

>the problem is that the import have only xls as an option and not txt or db4.
>i am trying to open it programmatically, as this sort of file will come to me on a regular basis.