Error performing VI export

[pattyc]

I am trying to do an export from MAS to Excel using VI. I set up the Excel spreadsheet, I set up the ODBC data source, and I set up the export job. When I run Test, I get results, but when I run the job for real, I get "Error 15 in program VIWX01 at line 0690". I get that error at that line for any job I try to run. I'm just trying to get the invoice numbers from AP.

I can do the db query from a Java app, but it takes 5-10 minutes just to connect, so that's why I'm trying this VI approach.

Anyone have any advice?

 

[BigLouie]

VI Export *YIKES* that is about the worst way to extract data. You can actually pull data with Excel. Just go to Tools, Import Data. Pretty fast. Normally when pulling data on a consistant basis I use Access and SQL Specific Pass Through Queries which allows me to code in the log on. Then I can populate tables with code and append queries.

you can reach me direct at bglouie@sbcglobal.net for step by step details on how to do the Access thing.