Is there an easy way to convert an Excel spreadsheet to a dbisam
database?  I see that I can save the spreadsheet as a dbase file or as
text or some other formats, so maybe they would import?

Jerry

"Jerry Blumenthal" <jerry@blumenthalsoftware.com> wrote in message
news:5C767AC0-66E1-4CC0-A3FC-0C0B0ECCC09E@news.elevatesoft.com...
> Is there an easy way to convert an Excel spreadsheet to a dbisam database?
> I see that I can save the spreadsheet as a dbase file or as text or some
> other formats, so maybe they would import?
>

You can save as csv and use the importtable method on the DBISAM ttable.
There are also inexpensive components available that will allow you to read
the workbook directly, but you would have to code the table insert, move the
columns, etc. If it is just a simple loading of a table, ImportTable might
do the trick. You can try it out with DBSYS with zero lines of code (open
the destination table, then Action/Import)

Robert

Jerry,

> Is there an easy way to convert an Excel spreadsheet to a dbisam
> database?  I see that I can save the spreadsheet as a dbase file or as
> text or some other formats, so maybe they would import?

BDETran can read dBase files.

Eryk

Jerry


Buy Mike Skolnick's import software - www.scalabium.com from memory - very good and handles wagdes of formats.

Roy Lambert

You can connect to an Excel spreadsheet using Delphi's ADO components.
Check out
http://delphi.about.com/od/database/l/aa090903a.htm?terms=delphi+excel

I usually read the file's range in with ADO, then convert to a memory table
for fast performance, then commit to a real table after processing.

John

"Jerry Blumenthal" <jerry@blumenthalsoftware.com> wrote in message
news:5C767AC0-66E1-4CC0-A3FC-0C0B0ECCC09E@news.elevatesoft.com...
> Is there an easy way to convert an Excel spreadsheet to a dbisam database?
> I see that I can save the spreadsheet as a dbase file or as text or some
> other formats, so maybe they would import?
>
> Jerry