Gdb file

[xy]

Is it possible to import gdb file in access?
Pls give me a hint.

Miran

 

[Joe Fallon]

Never heard of it.
So I say no.
If you can export your data to a common format like ASCII, Foxpro, Excel,
dBase then yes.

 

[xy]

I use Interbase & Firebird manager 3 to export gdb file to access format.
But I can do only for single table at once. I also want to convert
relationships.
Is there any SW tool to convert Interbase relationships to Access
relationships?
Thank you,
Miran

 

[Ernie]

Is Interbase an ODBC compliant database or does it have an
ODBC tool associated with it? If so, then you should be
able to do: File / Get External Data / Import (or Link)
and pull the information directly from your Interbase db.

Since you stated that you can export from interbase into
access format, I would have to believe that the above
would work.

If not, then I don't believe there is a way to do what you
want. Either way, you would have to create the
relationships manually in access.

I could be wrong though, I'm new at this.

 

[Jamie Collins]

I use Interbase & Firebird manager 3 to export gdb file to access format.
But I can do only for single table at once. I also want to convert
relationships.

You could try using ADO's OpenSchema Method specifying
adSchemaForeignKeys as the QueryType:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthopenschema.asp

Jamie.

--