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.
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.
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)