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

Martin, Donna M dmart06 at emory.edu
Fri Dec 19 11:56:18 CST 2014


VERY good questions, Susan, and I should have specified...See below:



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, December 19, 2014 12:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [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?  ALWAYS THE SAME FIELDS



>

> *         Change two datatypes

>



========Same question as above.  ALWAYS THE SAME DATATYPE CHANGES







> Susan H.

--

AccessD mailing list

AccessD at databaseadvisors.com<mailto:AccessD at databaseadvisors.com>

http://databaseadvisors.com/mailman/listinfo/accessd

Website: http://www.databaseadvisors.com

________________________________

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).


More information about the AccessD mailing list