Howdy All,

I was wondering what the best way to import lots of excel files was? I mean without the user having to go in and import each one manually. Any ideas?

I need more info too. Are you importing into multiple files, multiple tables in one file? etc.... There is a script step that allows you to import files. You might be able to run the import script for the first file, have it run another script to import the second file, then run the next script, etc...

I have never tested importing from mulitple documents before, but it should be possible. If you link enough of the import scripts to do say 5 at a time, then all you have to do is go back in and change the file names in those scripts for each import set.

Definitely make a copy before you try this out though.

well i'm attempting to bring in 50+ text files into a single table or records. So it would be just clicking import 50 times. The problem is, files need to be imported weekly and every week they will change, the files have the names formatted such that they are xxx_mmddyyyy.txt where xxx is the employee initials. I thought Import folder would work but apparently that just gives you info about the files in the folder....that was saddening and pointless. Well I hope that little extra bit of info can lead to someone possibly coming up with a suggestion. Thanks for replying.

Akira