How to trim blanks within MS Visual FoxPro VIEW
Posted on 2011-03-08
I have problem with extracting data from FoxPro to Excel.
1. I have defined FoxPro VIEW with ALLTRIM function to remove blanks from text fields;
2. Then within Excel I use ADODB.Connection and ADODB.Recordset to get data from FoxPro VIEW;
3. Then I use "CopyFromRecorset" to copy data from recordset to excel.
BUT the problem is that there is BLANKS at the end of text fields after they are copied to excel.
It seems ALLTRIM has not done its work. Any ideas.