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!