Hi,
I'm doing a little system with DBMan, I'm not finished yet but I'm pretty close to where I wana be.

One thing I have yet to look into is a way to import the data from my DBMan database into MS Access trough an internet connection. I'd like to be able to set up the whole procdure into a macro. This macro shuold do the whole thing with the simple click of a button.

Any suggestions on how this can be done? The server I'm working on supports Oracle/SQL database; would this be easier with an oracle database? If so I wouldn't hesitate to use DBMan for SQL.

I don't know of a one-step process. You can set up a two-step process, though.

First, set up a directory where the .db file will be. Download the file and change the extension to be .txt. (I guess that would be two-steps. )

Then, set up the macro in Access. Import the file, saving the import specs. Then create a macro that will delete the all the entries in the table and import the database file, using the specs you saved. You can do this all by one macro, which you can then assign to a button on a form in Access.


------------------
JPD

.....just to make my self very clear, I'm not realy asking about a macro: if you know a one step method for importing DBMan data into Access, I'd realy appreciate you letting me know about it.

thanks