Sage 100

Getting an excel - (DataFormat.error ) Odbc called failed . Using a Access data base that we have been using for 3 months. Data must be corrupt in Sage 100 but can't find it. Any thoughts would be appreciated. sage adv 2015

What table?? If you have VI, do a dump of the dates from that table into a csv, then open in Excel. There is probably a space in the date.

I did a data to excel just using the sotamas ODBC and no errors. Wouldn't that have error?

Excel will be more tolerant of a bad date. Access tagging a field as a date will choke if data with an invalid format is encountered.

Excel blows up for me on dates which is why I use VI csv as a last resort. Exact same everything??

It has to be a date right? Or should I be looking for something else. I am not finding a bad date .

Your error message says ""**Data**Format.error"". Unless that's a typo, it could probably be any column that has mixed data types. Is the source of the data you are pulling from Access a table, or some kind of SELECT query? If a query, can you alter the select statement temporarily to pull less records? For example, instead of: SELECT FIELD1, FIELD2 , use SELECT TOP 10 Field 1, Field2. You could also exclude columns from the query to determine which column the error is probably in.

I ran the PTQ tables in Access and nothing failed? It won't let me run the actual Select Query table . Saying not enough memory.

If I understand, a process is failing in Excel with a DataFormat.error from Odbc ... but when you try to run the query manually it quits with a not enough memory issue? I would do as @ChrisStAmand suggests and look for ways to trim your data.... even if temporarily. It might not even be a data error.

This program might make it easier to troubleshoot query / data issues. Just use a ""select * from tablename"" type query against an ODBC DSN. http://www.sliksoftware.co.nz/products/odbcview/

@RandyMarion the access quits for me when I try to run the select query table. Thanks @KevinMoyes I will try that. @ChrisStAmand will also try what you are saying. Looks like it is not going to be easy.

Try export to csv and open in notepad rather than excel.