My preferred method and one I suggest to everyone is to use MS Access. Setup some SQL Specific Pass Through Queries and using code you can create and export the file to wherever you want. You can use Windows Scheduler to run the process.

Another options is to us Knowledge Sync

Hey MK Thrasher,

VI actually uses both tables if you begin the export with the Details table (opposite of how you would do an import).  The Header tables are available if you create a VI job starting with the Details table.

You could use Big Louie's method, which is using a form of MS Query, or you could use Excel to create a file which you should then be able to save as a CSV.  You would have to construct a query, preferably using the Detail table as primary, link in the Header table and voila!

Hope this helps,

rclowe

Hey, RC Lowe

that did the trick. Thanks so much!!