Import/Export wizard

microsoft.public.sqlserver.programming

24 Mar 2006 8:24 PM

helpful sql

Hi all,
I want to copy data from one table and insert it into a view using
Import/Export wizard. But the wizard is not showing me my view in the
dropdown list for destination. So is this possible? If so, how?

Thanks in advance.

25 Mar 2006 12:43 AM

Select the 1st option "copy tables/views from source..." should allow to
specify the target table/view.

--
-oj

Show quote

"helpful sql" <nospam@stopspam.com> wrote in message
news:%2335coD4TGHA.1576@tk2msftngp13.phx.gbl...
> Hi all,
> I want to copy data from one table and insert it into a view using
> Import/Export wizard. But the wizard is not showing me my view in the
> dropdown list for destination. So is this possible? If so, how?
>
> Thanks in advance.
>