microsoft acess db gurus: need help exporting or converting a 80 file to a text file.

[LordSnailz]

So the deal is I want to pull the data off these access db files so I can write a perl script and start manipulating the data but the probelm is getting the data out of Access.

I've done the export file thing but the file created is HUGE!! Any other way I can do that will not take hrs. and will not be that big?

I have hundreds of this Access files that I need to run the perlscript on.

thanks in adv!

 

[MrChad]

Do you need every column? Perhaps you can format the date fields differently in your text file. There's not much you can do if you have a large database.

What sort of data is in there?

 

[EagleKeeper]

Binary to Ascii will always take more space.

 

[theknight571]

What do you need to do to the data? Can you do it "inside" Access using VBA?