Subject Re: How to Import/Export Excel Files
From James Lavery <lavery@gci.net>
Date Wed, 15 Mar 2023 02:15:34 -0400
Newsgroups dbase.getting-started



Outstanding!  Thank you Ken.  I am familiar with saving as a .CSV file; I'll check into the dBASE file functions.

James



Ken Mayer Wrote:

> On 3/14/2023 3:45 PM, James Lavery wrote:
> > New dBASE5 user.
> >
> > Win 8.1, x64 Processor/OS, 4 GB RAM, >200GB free storage, Excel 2016.
> >
> > Got my dbDOSv running.. Yay!
> >
> > Need help: How to Import Excel spreadsheets from dBase5, for the purpose of extracting the data.
> >
> > Back in the day I did this with dBase II, but it has been a loong time...
> >
> > Your help is greatly appreciated.
>
> I responded to a question about this in another thread. In Excel save
> the file as .CSV and then write some code to read it in ... as a .CSV
> file is pure text, dBASE 5 can read it use the file functions built into
> dBASE.
>
> The other option is to use DBFImport from dBase, LLC. It's a software
> package that you would need to purchase, but it should be able to do the
> job for you.
>
> 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
> dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
> dBASE DOS to Windows Tutorial:
> http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm
>