Update / delete and recreate access tables

[metro17]

I have a macro which deletes an recreates a table and imports data from a text file into the table and this happens after access database starts based on a preset time using the windows
scheduler. I want to know if its possible to update ( or delete and recreate ) the access table from the text file without starting the access database .
Thanks

[dcrake]

The major issue here is why are you deleting the TABLES instead of the CONTENTS of the tables. Then use an append query to copy the data into the existing table. By using the process you have in place will make the tables unstable as Access will determine at point of creation what type of field eacg field will be based on the first record in the file. Also it will assign 255 characters to each text field and will not assign a primary key.

Suggest you look at the option mentioned above.

David

[metro17]

I want to know if its possible to update the access table from the text file without starting the access database .
Thanks

[dcrake]

The target database does not necessarily need to be opened, however, some sort of engine must be activiated in order to run the macro or code. You could investigate the use of MS Scripting code to create a vbs file which can be run from the scheduler. If coded correctly Access will not be loaded into the foreground at any point. By using ADODB or DAO you can open it blindly.

David

[metro17]

appreciate the reply. Can you throw more light on this.Sounds latin to me .
Any test codes which I lay my hands on.
Thanks