Automate Import

[dwa]

Are there any tools out there that will allow automated import of data into
an MDB database table?

Import from any "open" format would also be acceptible: text,
tab-delimited, csv, xml, etc.

Thanks,

-- dwa

 

[Gary]

Good morning DW
I suggest you create a small (separate) front end which has linked the table you require. Create the necessary queries and funtions to handle the imports/exports and the set those processes into a macro or code and run the macro from the startup option
Allyou have to do then is to schedule the new db to start at a certain time etc and it will do the job for you

Have fu
Gary

 

[dwa]

Gary,

Thanks for the reply. Actually, I'm looking for a tool that can be run from
the command line or invoked from script, hopefully a tool with minimal
external dependencies. We've got a commercial product that is being
upgraded. The upgrade installation must pull data from one database
(different story) into an "Access" (.mdb) database, so we're looking for
tools that we can integrate with the upgrade installation for this purpose.

I wanted to see if something already existed along these lines before
"re-inventing the wheel" (but if such a 'wheel' doesn't exist, we can always
invent one).

-- dwa

Good morning DWA
I suggest you create a small (separate) front end which has linked the

table you require. Create the necessary queries and funtions to handle the
imports/exports and the set those processes into a macro or code and run the
macro from the startup option.

Allyou have to do then is to schedule the new db to start at a certain

time etc and it will do the job for you.