How to read all the tables and exprt them

[jsnunez]

Hi all

I need to write a macro or a VB program that will read all the tabbles in my database and for every table it will export it into a text file.

I have more tha 200 tables, how can I automate it

thanks
jsn

 

[PHV]

Have a look at the TableDefs collection ant the OutputTo or TransferText methods.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

...and your reason for this massive export is???

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[jsnunez]

Need then in unix

 

[SkipVought]

just as flat files or eventually into tables?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]

 

[jsnunez]

flat files

 

[SkipVought]

'K

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]