Subject | Conversion Utilities from Access |
---|---|
Author | moscow@cix.co.uk |
Post date | 2003-12-09T13:37Z |
Hi,
I'm trying to find a utility (that works) for converting Access97 or
Access2000 mdb files into FB1.5 fdbs.
The sql2gdb utility seems to work converting to FB1.03, but loses almost
everything, especially FK constraints (except the data and indeces) when
converting to FB1.5.
I also have the trial version of dbworkbench, but that gives me a
'Operation not supported' if I try to move an ODBC (mdb) datasource to FB.
Are there any other inexpensive variants around? - I have googled and
looked at the IBPhoenix site, but nothing seems to fit the bill.
Any help would be gratefully received.
Cheers
Terry Riley
I'm trying to find a utility (that works) for converting Access97 or
Access2000 mdb files into FB1.5 fdbs.
The sql2gdb utility seems to work converting to FB1.03, but loses almost
everything, especially FK constraints (except the data and indeces) when
converting to FB1.5.
I also have the trial version of dbworkbench, but that gives me a
'Operation not supported' if I try to move an ODBC (mdb) datasource to FB.
Are there any other inexpensive variants around? - I have googled and
looked at the IBPhoenix site, but nothing seems to fit the bill.
Any help would be gratefully received.
Cheers
Terry Riley