||Re: IMPORTING FILES
Andy Taylor <email@example.com>
||Wed, 24 Jun 2020 06:20:53 -0400
You are correct in that current versions of Excel will open dbf files (some, not all) but no longer offer to save content as a dbf table.
As Ken has pointed out in another post, in the dUFLP you will find exportData.wfm.
This does the job very nicely and you can learn a lot from the underlying code. However, there is quite a bit of interaction with the user.
If you want something that will just grab data from a simple excel file, let me know and I'll knock up a demo using OLE to get you started.
> 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.