ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   formula to display dbaseIII columns/rows in Excel Cells (https://www.excelbanter.com/excel-programming/276036-formula-display-dbaseiii-columns-rows-excel-cells.html)

Chris

formula to display dbaseIII columns/rows in Excel Cells
 
Is it possible using MS Excel 2000 to display a dbaseIII table within an
excel spreadsheet? I know I can open the dbaseIII file first and save in
excel format but I need something that can update the cells automatically.
I suppose I could also save the information in comma delimited and have a
formula read that information but don't know if thats possible either.

Are either of these possible? If not then does anyone know of a 3rd party
tool that might work for me.

Thanks,
Chris



patrick molloy

formula to display dbaseIII columns/rows in Excel Cells
 
Did you try Data / Import External Data ?


-----Original Message-----
Is it possible using MS Excel 2000 to display a dbaseIII

table within an
excel spreadsheet? I know I can open the dbaseIII file

first and save in
excel format but I need something that can update the

cells automatically.
I suppose I could also save the information in comma

delimited and have a
formula read that information but don't know if thats

possible either.

Are either of these possible? If not then does anyone

know of a 3rd party
tool that might work for me.

Thanks,
Chris


.



All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com