[AccessD] Importing multiple txt files

I planned on allowing the user to navigate to select the directory.

Janet

On Wed, Apr 1, 2009 at 12:21 PM, Hewson, Jim <JHewson at nciinc.com> wrote:

> Janet,
> Will the files always reside in the same directory or will the user be
> able to select the directory?
>
> Jim
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Janet Erbach
> Sent: Wednesday, April 01, 2009 12:12 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Importing multiple txt files
>
> Hello!
>
> I would like to programmatically import one by one all the text files in
> a
> given directory - usually around 30 files.  I've used code that I copied
> from http://www.mvps.org/access/api/api0001.htm to allow the user to
> browse
> through windows directories and select a single file to process...but
> now I
> want to process ALL the files in a given directory, regardless of the
> number
> of files.  I assumed I would build an array with the names of all the
> files
> and then loop through that array in my code to import and process them
> one
> by one.
>
> Does anyone know of code I could utilize that would allow me to
> identifity
> the names of all the txt files in a selected directory?  I'm lost when
> it
> comes to interfacing Access with Windows in this way!
>
> Janet Erbach
> NaturalHealthyConcepts.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ################################################################################
> If you have received this message in error, please contact the sender
> immediately and be aware that the use, copying, or dissemination of
> this information is prohibited. This email transmission contains
> information from NCI Information Systems, Inc. that may be considered
> privileged or confidential and is intended solely for the named
> recipient.
>
> ################################################################################
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>