From Ken Mayer <>
Date Tue, 23 Jun 2020 05:28:03 -0700
Newsgroups dbase.getting-started

On 6/23/2020 3:11 AM, Cornelius wrote:
> Andy Taylor Wrote:
>> Cornelius,
>> 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?
>> Andy
>>> Hi there,
>>> I am stuck again. Can someone please help me with importing a excel file with dbase12.
>>> Thanks
>>> Cornelius
> 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 Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial: