newbie question

[Christine Penner]

You won't be able to use ODBC unless its set up for that. Even if it 
is and you were able to connect you may not be able to see all 
tables. Only the tables that were set up for that. I have set up ODBC 
access for a few clients and I only ever done it for a few tables.

I would suggest trying to get the data into Omnis lists, then you can 
do what you want with it. Can you look at the data in the SQL browser in Omnis?

Christine

At 02:18 PM 25/01/2010, you wrote:
>I appreciate your response to my Newbie question but I have already
>tried that and it is
>requiring a user name and password in order to import the data into an
>MS Access
>DB. I have tried all my clients user names and passwords to no avail.
>Any ideas would be greatly appreciated.
>
>
>Hi David,
>I am not sure if it will work but if you go to the omnis.net website
>there
>is a ODBC driver that you can download for the Omnis datafile.
>Using this ODBC driver you would be able to connect other tools like MS
>Access to the datafile and you could use this to extract the data.
>
>Regards
>
>Dawid
>
>On 22 January 2010 20:57, David Victor <dvictor at qqsolutions.com
><http://lists.omnis-dev.com/mailman/listinfo/omnisdev-en> > wrote:
>
> > I'm a newbie and have an Omnis Db that I want to extract data from.
>This
> > is
> > a client's data base created by one of our competitors. When I try to
> > extract data, it is asking for a main file to extract
> > to. I do not have this file name and cannot get past this. Also, when
> > trying to get into the data, It asks for  a user id and password.
> > My client has provided me with their user id and password but it does
> > not work either.
> > Any ideas as to how to get this data into a different format for
> > manipulation?
>
>_____________________________________________________________
>Manage your list subscriptions at http://lists.omnis-dev.com