| Subject | Re: IMPORTING FILES |
| From | Ken Mayer <dbase@nospam.goldenstag.net> |
| 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 -- *Ken Mayer* 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 | |