Automate table import with a twist...

[MatsHulten]

Can someone help me out with this one?

I need to automate an import to an Access DB from another system.

Problem is that the other system has a native loginbox that appears whenever I try to access data from it.

Any thoughts how to get around this?

-Mats

 

[WP]

What is the other system ?

Sounds like you need to pass the user and password to the connection code.

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[MatsHulten]

The other system is a switchboard using SQLBase.

And yes, perhaps that's the problem as it is an loginbox, but the DB doesn't require any password.

The only thing I have to do is to press the OK button to get to the "choose table" box.

I need to do this automatically but how???

-Mats

 

[WP]

SQLBase ?? Not heard of this one... no matter ther are many more that I haven't heard of .

Try contacting the vendor of SQLBase and see what they have to say about building interfaces to it.


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[MatsHulten]

Yup, trying that right now.
Centura Software if your'e interested...

In the meantime... anyone else, with helpful suggestions?

-Mats