I usually export the spread sheet as a Comma Separated Values (CSV) file with Excel, and then use a unit I wrote to import it into my application.
My unit reads CSV files one row at at time and parses it into all the various fields. I use variants - does D6 support them? Anyway, it is simple to create SQL queries to export the fields into a relational database. Best regards, Kevin G. McCoy --- In [email protected], Ahmad $arhan **** <mahdoo...@...> wrote: > I have excel file with 2 columns ( ID, Value), what I need is to insert all > values from the excel sheet to my DB.GDB (table name: rntmgmt) and this > rntmgmt table have ID as primary key, I am using Delphi 6. > > any idea please to insert values using SQL or other methods,
