Subject Re: [firebird-tools] excel import
Author Martijn Tonies
Hi Peter,

> I have a problem where I need to import an excel table into a
> 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.

Well, if you can use ODBC to access the Excel source as
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