Sage 100

I am trying to import data into Sales Order via an ODBC connection. When I try and browse a field from the ODBC Table selection screen I get an ""ODB 'xxx' is full"" error message. Any thoughts of what would be causing this?

What Sage 100 version? What is the odbc data source program Access, Excel, something else?

Try a reboot????

You say you're trying to import INTO Sales Order via an ODBC connection. Are you using the SQL version? Sage 100 Standard and Advanced use a ready only ODBC driver so you should be using the Visual Integrator module to import in.

Sorry about the lack of details. This is Sage 100 Std, version 2013, PU 3. I am using VI for the import and the source is an ODBC datasource (MS Access ptq -Jeff likes this) where I am pulling info from job cost into SO. It works on my local install, but not at the client site.

Did you try uninstalling and reinstalling the workstation? Maybe there's something wrong with the ODBC connection.

Check your Access database. When run the PTQ, does it populate? Can't tell you the amount of hair loss trying to figure out why the Access DB works on the office install but refuses to budge at the client....

Thanks for all of the quick responses on this. If I figure out a solution I'll post it here.