Sage 100

VI tracking import using ODBC Access 2007 database. Can add table and fields to Vi job, but when trying to browse receive error 15 operating system command failed, VI_ImportJobMaintenance_bus.pvc 2878 and when testing the import receive Error 15 VI_ImportReadRecord.pvc Line = 484, error whiel reading import file {wdx}{odb}Connectship Access DB;;User=xx, PSWD=xxxxx The access DB is pulling a specific date range from a SQL DB and I'm not sure if it's that relationship causing the trouble. I can't pull data into excel either using odbc query. Any help would be greatly appreciated.

Make sure there are no numbers in the field names - begin removing fields until you can get the test sqy query to work successful.

Could it be your date syntax? The date syntax used should be that of the target db engine. For Access - #12/31/2011#, but SQL Server is '20111231'.

thanks for the ideas! We'll check out field names and the date syntax and let you know

I thought SQL was yyyy-mm-dd.

Either work according to ISO 8601 - 'YYYYMMDD' or 'YYYY-MM-DD'