Export DBF memo field
-
- Posts: 7
- Joined: Tue Oct 10, 2017 12:44 pm
Export DBF memo field
Hello,__My current 8.0 version of R&R does not support exporting of memo fields to a dbf file type. Do the more recent versions support this?__Will
=> RE: Export DBF memo field
You cannot include a memo field in a DBF export even with a later release of R&R.____Kathleen__R&R Support
-
- Posts: 17
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Export DBF memo field
If you do a CSV export, the contents of the Xbase memo field will be included and can be pulled-up in Excel.____hth
-
- Posts: 14
- Joined: Tue Oct 10, 2017 12:44 pm
===> RE: Export DBF memo field
Is there anyway to keep from loosing the leading zeros in text fields when exporting to a csv as excel treats the field as numeric and eliminates the leading zeros.
====> RE: Export DBF memo field
just insert a dummy row as the first row with characters in the field being treated as numeric - that causes excel to keep it as text. Later just delete the dummy row. make sure that dummy row contains data in all the other fields of the type you desire.____example__(NEW DUMMY ROW) ABCD __ORIGINAL FIRST ROW 0456__etc__