Martin, Donna M
dmart06 at emory.edu
Fri Dec 19 11:42:45 CST 2014
Good afternoon, all! 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 * Change two datatypes * Add filtering criteria * Trim leading characters from one field At this point, the table does not have a PK. Once the table has been QC'd, the data will then be appended to a second FINAL table where an autonumber will be added. I'm way out of my comfort zone here, and am wondering if you can give me any thoughts on this...or should I just throw in the towel now and leave town? Again, any help will be much appreciated! Thanks. Donna ________________________________ This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments).