| Subject | Re: IMPORTING FILES |
| From | Andy Taylor <andy.taylor.1959@outlook.com> |
| Date | Wed, 24 Jun 2020 06:20:53 -0400 |
| Newsgroups | dbase.getting-started |
Cornelius, 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. Regards, Andy > 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. > > Thanks, > > Cornelius. | |