Exporting the result of a view to a table in the same database

[Rahel]

I need to extract the results of a view to a table in the same database. The table has exactly the same column structure as the view. I tried to create a DTS package to do this but, you can not see views when creating a DTS package(only tables are visible).

can someone help? [sig][/sig]

 

[foxdev]

insert into MyTable select * from MyView [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]