want to export .mdb, not .txt

[Guest Close Guest]

I need to get a file/directory structure of a folder on my server. I am able to retrieve the data in .txt format, and open it in Access, only it produces only 1 table. My coworker says that you are able to have Exporter Pro export into Access and it formats it in multiple tables.
I tried changing the output file in properties to .mdb, but Access does not understand the format.

[Guest Close cmccullough]

Re: want to export .mdb, not .txt

Exporter Pro is not able to create any output file formats other than delimited text files.

[Guest Close Guest]

Re: want to export .mdb, not .txt

What does the hyenarpt.mdb file come from / do? My collegue says that exporter pro should be able to import the data into this Hyena db template

[Guest Close cmccullough]

Re: want to export .mdb, not .txt

It is a database with some 'canned' reports in it that takes input from Hyena's right window. The output from Exporter Pro would not import directly into the tables that are in there.

But, you can import text files into your own Access tables and create queries and reports using the Access Wizards.

[Guest Close Guest]

Re: want to export .mdb, not .txt

thanks for all your help