Access integration with another business system...how?

[CJKCyclone]

I need to find a way to integrate our software that was created in Access 2000 with another business system. Our plan is to just export a file (flat text, excel, etc) containing the data to a certain directory and the business system will come get it on a daily basis.

I'm wondering if it is possible to automate a process where Access will create this file and export it to a chosen directory at a scheduled time. The file would be from a table that would be created with all appropriate data. Anyone have any experience with this...is it possible? I realize that it may take using tools outside of Access.

Thanks all!

CJK

 

[jfgambit]

You can either create a Macro that runs off a command button utilizing the TransferText properties, or write VB code utilizing the DoCmd.TransferText command.

These process can be set to run either automatically based on a scheduler, or run through a command button.

Search the forum for DoCmd TransferText.

Let me know if this helps or if you need examples.

 

[The_Doc_Man]

As an off-the-wall approach, you can also create a macro that performs the text export of your table/query. Then you can put something in the Windows Scheduler to execute once per day at a specific time. (This requires your system to be running at the time and not locked.)

If you take this approach, you need to read the help files to get the correct syntax for the /X command-line option. Look up the subject "Command Line" in the help files to read up on it. Basically, what you would do is use the scheduler to run Access to execute the macro that performs the export.

The production version of this macro would have to include the Quit (Access) action as its last step. For testing, of course, you would not include that step.