Export DBF memo field

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Will_(Guest)
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

Export DBF memo field

Post by Will_(Guest) » Wed Jul 09, 2003 3:01 pm

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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Export DBF memo field

Post by kfleming » Wed Jul 09, 2003 5:37 pm

You cannot include a memo field in a DBF export even with a later release of R&R.____Kathleen__R&R Support

Emetsky_(Guest)
Posts: 17
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Export DBF memo field

Post by Emetsky_(Guest) » Tue Jul 15, 2003 5:22 pm

If you do a CSV export, the contents of the Xbase memo field will be included and can be pulled-up in Excel.____hth

MICHELLE_(Guest)
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Export DBF memo field

Post by MICHELLE_(Guest) » Fri Aug 22, 2003 12:18 pm

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.

Nick
Posts: 103
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: Export DBF memo field

Post by Nick » Sat Aug 23, 2003 10:08 am

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__

Post Reply