Allow MS Access to call the exporter?

[Guest]

I have a DB that I populate with the .txt files that Hyena produces. I am trying to set a macro to call the exporter.exe, but it only shows me the Version on a DOS window and then stops, never doing the export. Any ideas?

[cmccullough]

Re: Allow MS Access to call the exporter?

Make sure you're command specifies where to find the ini file, such as:

exporter.exe "c:\program files\hyena\export.ini"



[This message has been edited by cmccullough (edited 04-10-2003).]

[Guest]

Re: Allow MS Access to call the exporter?

I did that. Still the same results.

[This message has been edited by MPG (edited 04-10-2003).]

[This message has been edited by MPG (edited 04-10-2003).]

[cmccullough]

Re: Allow MS Access to call the exporter?

Send more details on this to [email protected]. How you are calling it, commands you are using, etc.

[Guest]

Re: Allow MS Access to call the exporter?

Was this ever solved? I'm having the same problem. I posted a new topic this morning on the same problem. I tried starting Exporter with another batch file using the following syntax:
cmd.exe /k c:\Progra~1\Hyena\exporter.exe

It works fine. If I call the same batch file from within Access using the shell command, Exporter just returns the version number.

Gary

[Guest]

Re: Allow MS Access to call the exporter?

Hey....I figured it out. The problem was that the batch file I used didn't specify the path when the command prompt opened up. Without the right path at the prompt, Exporter can't find the Export.ini file. I was able to start Exporter by calling Exporter.bat. Here is the contents:
@ECHO OFF
PROMPT $p$g
PATH c:\Progra~1\Hyena
exporter.exe

Gary