Importing in to Access 97 using vb script with jet engine

[teabags]

Hi

I want to import a textfile in to a MS acces data base stored on a network drive.

The only problem is that MS Access 97 isnt installed on the network computer so I was wondering if I could import in to the ms access data base using the jet engine?

 

[pdx_man]

You should be able to do an Append query from your db into that A97 db. When creating the Append query, look at the properties. There is an item for destination DB. Use that code generated in your script.

 

[teabags]

But what I want to do is slightly different.

I have an access database installed on a network server. Everyweek the data in this database is refreshed with a new input from a text file.

the textfile is a simple comma delimmeted file

The problem is that MS access isnt installed on the network server that holds the MS access database.

I want to automate the weekly import of the textfile in to the access database that is stored on the access server.

Have u any ideas how i can do this?

There are a lot of vb scripts out there to take in an import by opening the database

Please Help