[AccessD] Automate import of csv data, change datatype, field names, etc

Just a few questions that might help hone the responses.


> It's been a very long time since I have posted here, and am a bit rusty on
> my Access programming, and would be extremely grateful for any suggestions
> you may have.  In a nutshell, I need to automate-as much as possible--a
> procedure for research interns/postdocs.  This procedure will be run
> anywhere from 1-5 times a week, so it's worth a little thought as to how to
> make it happen for them.  Here's what needs to happen:
>
> *         Import raw data from a csv file into a table
>
> o   Ask for the begin date of import (Not req'd, but would be nice)
>
> *         Change some of the field names
>

========Will it always be the same fields or do you need something more
flexible?

>
> *         Change two datatypes
>

========Same question as above.



> Susan H.