Hi, You can access excel files using ADO components (ADOConnection, ADOQuery) if they have data in table format, which is so in your case.
You would need 2 set of data components. 1. ADOConnection, ADOQuery - Connect to required excel file / worksheet. You can get examples of accessing to excel files using ADO on the net. Check link : http://delphi.about.com/od/database/l/aa090903a.htm 2. TDatabase, TQuery - Connect to Interbase database using BDE. Using these 2 set of components, you can write code to have a loop to traverse through excel data and insert into interbase database. Hope this helps, Vishak Bhat --- In [email protected], Ahmad $arhan **** <mahdoo...@...> wrote: > > Hi, > > anybody can help me in thins please, > > 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, > > THANKS.
