Allday Consulting's Peachtree and QuickBooks Support Boards

I'm looking at a way of recovering the information in a particularily long item description/memo field. Over 80 chars. It looks like the reports go to a maximum of 80 characters. So is there anything else I could use to get that information?

Basically the description has some product information and notes on the software, then it has the serial numbers. I believe the export function should do the trick. Any other options?

Thanks

Change to Single-User mode, then go to File > Utilities > Export > Lists to IIF Files... IIF's can be opened in Excel, and will contain the full text of the Description fields. Note that Exporting the Report itself will not work, it will only have the truncated Description that shows up on the report itself. IIF is the file format QB uses to import/export data among QB files.

An alternative would be to use QODBC to allow integration with Crystal Reports, if you want the data outputted directly into report format.

Sadly that function does not give me the information I'm looking for. I'm looking for a edited item description, every individual order has a serial number entered into the product description. While using a custom field is idea it wasn't done when was setup. So then, is there a way to extract that information? I'm not familiar with Crystal reports either.

There must be some kind of ODBC which would allow me to read the orders and get those numbers? (If I make it myself or otherwise). Is there a community which specializes in this kind of stuff?

Thanks,

http://www.qodbc.com/

I just mentioned Crystal as one way to utilize the ODBC. Any ODBC-compliant application should be able to utilize it, including VB, Access, Excel, whatever. Note that the read-only version of QODBC is already included with Enterprise. The site may have a more recent version, however.