Mega Search
23.2 Million


Sign Up

Make a donation  
Import csv file into InterBase XE/XE3  
News Group: embarcadero.public.interbase.general

I have just acquired RAD XE7 and want to start working on a project.  I have an old Database file which I exported to an excel CSV format.  I need to import this file into InterBase but don't see any help or free tools that will do that.  I don't want to spend $$$$$ for this as I am only needing to do this once.  Program tips/advice needed.  Thanks.

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 2-Jan-2015, at 12:00 PM EST
From: Chris Stueck
 
Re: Import csv file into InterBase XE/XE3  
News Group: embarcadero.public.interbase.general
Chris Stueck wrote:
> I have just acquired RAD XE7 and want to start working on a project.  I have an old Database file which I exported to an excel CSV format.  I need to import this file into InterBase but don't see any help or free tools that will do that.  I don't want to spend $$$$$ for this as I am only needing to do this once.  Program tips/advice needed.  Thanks.
>
You can it with IBConsole. First Create the table, then Right click in 
the Data tab and there will be an import option.

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 5-Jan-2015, at 10:44 AM EST
From: quinn wildman
 
Re: Import csv file into InterBase XE/XE3  
News Group: embarcadero.public.interbase.general
Chris Stueck wrote:
> I have just acquired RAD XE7 and want to start working on a project.  I have an old Database file which I exported to an excel CSV format.  I need to import this file into InterBase but don't see any help or free tools that will do that.  I don't want to spend $$$$$ for this as I am only needing to do this once.  Program tips/advice needed.  Thanks.

You might be able to import it using the IBX TIBImportDelimitedFile.  IBDataset 
and IBSQL both have a BatchInput method that takes this as its parameter to so 
inputs.

-- 
Jeff Overcash (TeamB)
       (Please do not email me directly unless  asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted  corridors of Whitehall.
              (Fish)

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 2-Jan-2015, at 12:15 PM EST
From: Jeff Overcash (TeamB)