Automated 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

 

[Steve Schapel]

Dwa,

This can be accomplished "manually" via the File|Get External Data menu.
The procedures that this import wizard does can be automated with a
macro or VBA procedure using the TransferText action/method. I suggest
you have a look at the help topics on these, have a go, and then post
back again if you need any more specific help.

 

[dwa]

Steve,

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