Exporting dBASE IV memo field to ASCII file without using dbase IV

Exporting dBASE IV memo field to ASCII file without using dbase IV

Post by Todd Ower » Sat, 13 Jun 1998 04:00:00



I need to export dbase IV files, which contain memo fields, to ASCII files,
without using the dbase IV database engine.  I have a Clipper program that
will do this for a .dbf that does not contain a memo field.  Is there a way
to do this for a .dbf that does contain a memo field?

Thanks in advance for any suggestions.

Todd Owers

 
 
 

Exporting dBASE IV memo field to ASCII file without using dbase IV

Post by Wolfgang Schmal » Sun, 14 Jun 1998 04:00:00


Hello Todd!

The most easiest way is to
        use dBASEIV.dbf
        set textmerge to myfile.txt
        select dBaseIV
        scan for !deleted()    && or any other FOR-clause
            \\<<variable>> <<memofield>> <<any other variable>>
        end scan
        set textmerge off

For further information look in the manual or helpfile topics:Textmerge,
dBASE

mfg

Wolfgang Schmale

Todd Owers schrieb in Nachricht

>I need to export dbase IV files, which contain memo fields, to ASCII files,
>without using the dbase IV database engine.  I have a Clipper program that
>will do this for a .dbf that does not contain a memo field.  Is there a way
>to do this for a .dbf that does contain a memo field?

>Thanks in advance for any suggestions.

>Todd Owers



 
 
 

Exporting dBASE IV memo field to ASCII file without using dbase IV

Post by Rainald Taesle » Sun, 14 Jun 1998 04:00:00


Todd Owers schrieb in Nachricht

Quote:

>I need to export dbase IV files, which contain memo fields, to ASCII files,
>without using the dbase IV database engine.  I have a Clipper program that
>will do this for a .dbf that does not contain a memo field.  Is there a way
>to do this for a .dbf that does contain a memo field?

-----
1.) Difficult if you don't have dBIV; it would have to be done with a
program, which could be written either in dBASE (any version from dBIV on,
incl. Visual dBASE) or in Clipper.
An advanced programmer could write a program in any language (TP, C, C++) to
do the job.

2.) There always was a number of wordprocessors that could read dBASE-data
incl. MemoFields; Lotus AmiPro could do that, WinWord too, but with certain
limitattions.

3.) The way of exporting to "ASCII-files" would depend on (a) how long the
texts in MemoFields are, (b) what was to be done with the results.
As the length of MemFields is nearly unlimited, under normal circumstances
it does not make sense to put "normal" fields and MemoFields into the same
ASCII-file - neither delimited, nor SDF would work with longer entries.
So producing separate files, one for echo the Memo of each record mostly is
the only way to proceed.

Regards

Rainald
--------------------------------------------
Prof. Dr. Rainald Taesler
Fachhhochschule Heilbronn
Heilbronn/Germany

http://www.fh-heilbronn.de/Fachhochschule/Fachbereiche/BWL/TB/dozente...
--------------------------------------------
Come and visit the "official" Borland NewsGroups with 12 sections on Visual
dBASE
-> forums.inprise.com
that's where the beef is served <g>

 
 
 

1. How to convert FoxPro 6.0 to DBASE IV and DBASE IV to MSSQL

Hi out there,

I'm new to FoxPro.
I have to migrate abourt 150 FaxPro 6.0 *.dbf tables to MSSQL 8.00

I think, I have to do that in 2 steps:
1 - Convert FoxPro *.dbf to DBASE IV
2 - Import DBASE IV into MSSQL 8.00

I want to do that in a script.

But, I don't know the commands and if this is the right way to do that.

Any suggestions, examples would be great!!

With kind regards,

Herman

2. Libs in Pxwin 7 (32 Bit)

3. Accessing the memo field of a DBase IV file

4. Opportunity: Informix DBA

5. DBASE IV ASCII FILE INVES

6. DROP/Create Tables

7. dBase IV ASCII file investigation.

8. increase WAL_FILES

9. dBase IV memo field corruptions

10. DBase IV Memo field corruptions - multiuser

11. dbase iv memo fields with SQL?

12. Margin Setting for memo Field in Dbase IV for VMS

13. MEMO field question/dBase IV