Is this a one off job? How many records? If it's a one-off and there's not too many records I'd use the delphi editor with some macro magic to turn the excel file into a script with insert statements that can be run directly on Interbase.
Walter 2009/8/18 Ahmad $arhan **** <[email protected]> > > > 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, > > [Non-text portions of this message have been removed]
