Subject Re: Import/Export not all excel data can be imported From Ken Mayer <dbase@nospam.goldenstag.net> Date Tue, 14 Mar 2023 21:32:43 -0700 Newsgroups dbase.getting-started On 3/14/2023 4:12 PM, James Lavery wrote: > Hello Dirk, > Found enclosed below note (from Nov 2022) regarding Excel import/export. > > Info helpful to me: "append from array" > > My question: How do I identify to dBase5 that the Excel spreadsheet is an Array?? > > The spreadsheet contains only letters and numbers. > > Developer Desktop does not recognize .xlsx files. > > What must I do to spredsheet/data for it to be recognized by dBase5 as an array. > > Help is greatly appreciated. With dBASE 5 you are going to have to save the contents of the XLSX out as CSV format (Comma Separated Values). This can be done with the File, Save as option in Excel. From there you will probably need to write some code to read the data in as needed ... or, you could take a look at software from dBASE LLC, such as DBFImport ... please visit the dBASE website for that. 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