||Re: IMPORTING FILES
Ken Mayer <firstname.lastname@example.org>
||Tue, 23 Jun 2020 05:28:03 -0700
On 6/23/2020 3:11 AM, Cornelius wrote:
> Andy Taylor Wrote:
>> Much, much more information needed. There are two main methods to achieve this:
>> 1) get the user to output the file from excel in csv format and dBASE appends it from there into a file that is empty and prepped with the right fieldnames.
>> 2) get dBASE to handle it all using Excel as a puppet via OLE automation.
>> Which do you want?
>>> Hi there,
>>> I am stuck again. Can someone please help me with importing a excel file with dbase12.
> Hi Andy.
> Thanks for the answer. THe older excel alloed me to import dbf files but the newel version does not.
> I would like to know more about option 2.
First, in the dUFLP you will find exportData.wfm which will move data
from tables in dBASE to various other formats, including Excel; and
there is ImportData.wfm which goes the other way ...
That's a starter. This kind of thing is also covered in my books, and
there are multiple threads, probably in the programming newsgroup here
on this topic.
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm