help with scripting

[Nat]

Frist, I haven't done much in scripting so any web sites that help would be
much appericated.

Second I need to develop a script or a macro to import a text file in ms
access. Which will then be placed in the windwos task scheduler to an auto
import with script or macro. I have no clue where to begin!!

Thanks for any help

 

[Daniel Pineault]

First off you need to get your terminology right. You are looking for vba
programming and not scripting. Scripting is a different language all to its
own. There are similarities, but none the less there is a difference.

As for importing a text file take a look at
http://www.tek-tips.com/viewthread.cfm?qid=1078739&page=10
http://www.blueclaw-db.com/transfertext-docmd.htm

Hopefully they get you started.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com
Please rate this post using the vote buttons if it was helpful.

 

[Klatuu]

The easiest way, since you are not familiar with VBA would be to use a macro.
You will want to use the TransferText Action.
To make it run autmatically from the Task Scheduler, name the macro Autoexec
When an Access mdb is opened, it will automatically run a macro named
Autoexec.
As the last line of the macro, you will want to use a Quit action.

One other thing you will need to know. When you need to open the mdb
without running the macro, hold down the shift key when you open it and it
will bypass the automatic startup.