I'm sure this is similar to the issues others are having when trying to get PII data from Sage to another application, but I'll ask anyway.
Our client has an Access database. They need First Name, Last Name and Status. Anyone figured out how to do this without writing a Crystal report?
Thanks,
You could create a custom employee lookup, set column size of employee # to 0 and add columns you need. Use that lookup and export to Excel
User must have rights to PII data.
You could probably use a BOI script of some sort (instead of ODBC)... and I understand (through the 90-Minds group) that Dan Burleson has a technique which might work (but I have not tried it myself).
…
