[AccessD] Load from test AGAIN

You don't give any specifics on where your problem occurs, Martin.  Is
it in the file system object handling, the LoadFromText, or what?  I've
usually had fewer problems with any kind of iterative operation on files
when I created an array of the filenames (with or without extensions) to
be retrieved using Dir or file system object and then passed that into a
routine to do the actual handling, with some kind of test in place to
see if one item has succeeded before passing in another item.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, October 18, 2006 11:11 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Load from test AGAIN

Ok this has me beat
 
No matter what I try I cant get it to loop through a folder and import
the exported text files. Tried Martys stuff, Drews stuff and my own.
Used file system object to return only the file name without the
extension and no luck.

Any help greatly appreciated.
 
background
 
Access database objects exported as text files into C\|Forms
 
I think need to LoadFromText all the objects in said folder back into
database.
 
This cannot be as difficult as it seems. One at a time and naming the
files it works. Only when I go to look through all the objects does it
fail. This is almost my last example file I need and its melting my
head.
 
 
Martin
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477