Subject | Re: [firebird-tools] excel import |
---|---|
Author | Martijn Tonies |
Post date | 2004-07-02T12:58:37Z |
Hi Peter,
a "database", then Database Workbench can help - its
Schema Migrator tool can help you to map the types to
a new Firebird table. Later on, you can use its Datapump
tool to transfer the data from the Excel ODBC source to
Firebird.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> I have a problem where I need to import an excel table into aWell, if you can use ODBC to access the Excel source as
> database. I know I could import comma delimited files but only if the
> table structure is know.
> Does anyway know of any tools that may help or better still create
> the tables from the excel source.
a "database", then Database Workbench can help - its
Schema Migrator tool can help you to map the types to
a new Firebird table. Later on, you can use its Datapump
tool to transfer the data from the Excel ODBC source to
Firebird.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com