Nov 28, 2005 #1 jsnunez MIS Feb 4, 2004 72 0 0 US 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
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
Nov 28, 2005 #2 PHV MIS Nov 8, 2002 53,708 0 0 FR 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 Upvote 0 Downvote
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
Nov 28, 2005 #3 S SkipVought Programmer Dec 4, 2001 47,485 7 38 US ...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] Upvote 0 Downvote
...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]
Nov 28, 2005 #5 S SkipVought Programmer Dec 4, 2001 47,485 7 38 US 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] Upvote 0 Downvote
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]
Nov 28, 2005 #7 S SkipVought Programmer Dec 4, 2001 47,485 7 38 US 'K Skip, [sub] [red]Be Advised![/red] The band of elderly oriental musicians, known as Ground Cover, is, in reality... Asian Jasmine![/sub] Upvote 0 Downvote
'K Skip, [sub] [red]Be Advised![/red] The band of elderly oriental musicians, known as Ground Cover, is, in reality... Asian Jasmine![/sub]