import multiple text files into Access 2003(different file names)

[jonvillalva]

Hello all,

I am attempting to import many text files into an access 2003 db that
has been designed to automatically receive data. I came across this old
thread,

http://groups.google.com/group/micr...ple+text+files+access&rnum=1#aa879d1dff2b2b1a

that calls for a macro to list the files recursively using the dir
function that was once included in Access 2000 (and 2002?). In Access
2003 the dir function is no longer available. I know that I am not
working in sandbox mode which would block unsafe expressions. Is there
a work around for this anyone has knowledge of or a module substitute
that someone may be willing to help me with? Any help or a good old
push in the right direction is much appreciated. Thanks.

Jon V

 

[John Nurick]

The Dir() function is the same in Access 2003 as in earlier versions.
Problems like this are often caused by a missing reference in the VBA
project (maybe a reference with no obvious relevance to the missing
functions): see
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html for details
and fixes.

 

[jonvillalva]

Thank you for the response John,

I cannot seem to find the problem. It does not appear to be an
unreferenced library and I haven't any custom vba written for this that
it would have otherwise referred to. I have looked on many of the
computers where I work and my two at home and none of these have the
dir function listed. The only place that I found the dir finction was
on an older computer at work that is running Access 97. Is there a way
I can export this reference from the 97 computer and register it in the
db that I am working on? Once again thanks for your assistance.

Cheers,

Jon V

 

[John Nurick]

Jon,

Read Doug Steele's instructions carefully. You can get a "bad" reference
causing this sort of problem without any of them showing up as "missing"
in the list.

If having worked through Doug's instructions you still can't use Dir(),
it's a coding problem not a data import/export problem. I suggest you
post in a coding newsgroup (e.g. microsoft.public.access.formscoding or
microsoft.public.access.modulesdaovba).