Import CSV - Using a Specification - Default Value in Column - Automating The Import

[cmcfarland]

Hello!



I'm an MS SQL person working in an MS Access world for a little while here, and while I'm enjoying the experience I do find that I'm at a loss for being able to get some things done that would be really easy for me to pull off in MS SQL.

So, I wonder what you guys will think about what I'm trying to do...

Two main goals:

First is to have my Import process run automatically, instead of having to fire off the process from an Outlook Task, which seems to kind of be the available level of automation where the Access GUI is concerned.

I've looked into this a bit, and so far I've been overwhelmed with what's involved in writing a macro to get this done, and I think I've seen some .vbs type solutions, too, that were in the same category.

Probably easier than I'm perceiving it to be right now, and maybe I'll need to get my feet wet there.

Second is to have a column updated with a fixed value.

There's a column that's not in my import file, and I'll want the same word inserted there each time.

I don't care if it happens along with the import, or if I go back and have null values updated with the right string, either.

SO, that about sums up what I'm trying to get done.

Thanks for taking a look!

[June7]

I use VBScript to open Access db and run a procedure. Windows Task Manager runs the script every Monday morning.

[cmcfarland]

Sounds reasonable!
Is this in the realm of things that I just need to comb Google for in order to light the way?

[June7]

Example was given in your other thread https://www.accessforums.net/import-...ion-48324.html

Create a VBScript file with text editor, I use Notepad. Save the file and change the file extension to vbs.