Perform an operation on multiple files.

[newuser]

All,

I have 600+ .mdb files and I am interested in 1 table within each file. I would like to extract that table from each file to a simple .txt file so that I may create a program which reads this data (programmed in a language of my choosing). I know how to do this for an individual file, but is there a way to script this such that Access knows which directory to look in, and will perform this operation to all files thus creating 600+ .txt files? This would be a huge help, thank you!!!

[ajetrumpet]

well, you could possibly use the 'opendatabase' method in vba to open all 600 and close them one at a time. an export function would be best to throw the tables out from each db, but with that large number, there is a huge risk of corruption at the very least.

if this was even possible though, breakpoints would absolutely necessary every 5 files, or maybe every 10 because the memory would get so corrupted and jumbled based on the speed of code execution that anything could happen. your system might even crash. that's IMO of course.

[weekend00]

another thinking:
1 find all mdb files by DIR if you do have the list yet.
2 link the table to currentdb and export one by one

I have the codes to do all these because I just finished updating my hundred's of mdb files. Please see my attachment if interested.

[TheShabz]

...how does one have 600+ .mdb's to begin with?

[newuser]

2 years worth of data.

[TheShabz]

I've got about 50 years' worth in 1 database. 600+ is just a staggering number.

[newuser]

thus my desire to somehow script within windows.

[TheShabz]

Good luck with it. I'd like to know how that goes. I don't envy your position right now.

[ajetrumpet]

...how does one have 600+ .mdb's to begin with?

been on my mind since I first clicked this thread. link.

[weekend00]

I have hundreds mdbs too.
every month I create 5-10 new ones, that's almost 100 a year.
now and then I backup the databases, 50 more in a year,
...