| Author |
Export more than one table
|
|
|
| There is a requirement to export more than 1 table (about
10 tables) from a SQL Server 2000 database to an Access
Database.
Is it possible to be done by DTS ? If I create an Access
Database and import all those files from SQL Server, is it
the easiest way ? Besides, it is an one off task.
Your advice is sought.
Thanks
| |
| Andrew J. Kelly 2005-07-18, 3:23 am |
| This should be an easy task for the DTS Wizard and it certainly is an online
operation.
--
Andrew J. Kelly SQL MVP
"Peter" < anonymous@discussion
s.microsoft.com> wrote in message
news:06f201c58b29$ad
031eb0$a401280a@phx.gbl...
> There is a requirement to export more than 1 table (about
> 10 tables) from a SQL Server 2000 database to an Access
> Database.
>
> Is it possible to be done by DTS ? If I create an Access
> Database and import all those files from SQL Server, is it
> the easiest way ? Besides, it is an one off task.
>
> Your advice is sought.
>
> Thanks
| |
|
| Dear Andrew,
Thank you for your hint.
Besides, I would like to update all the name and address to "anonymous" and
"unknown". Can it be done with the wizard ?
Thanks
"Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
news:%231e6jvziFHA.3336@tk2msftngp13.phx.gbl...
> This should be an easy task for the DTS Wizard and it certainly is an
> online operation.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Peter" < anonymous@discussion
s.microsoft.com> wrote in message
> news:06f201c58b29$ad
031eb0$a401280a@phx.gbl...
>
>
| |
| Andrew J. Kelly 2005-07-18, 9:23 am |
| You can use a data transform task but I would probably just run a statement
at the end to do the update.
--
Andrew J. Kelly SQL MVP
"Peter" < anonymous@discussion
s.microsoft.com> wrote in message
news:enqwG93iFHA.3672@TK2MSFTNGP10.phx.gbl...
> Dear Andrew,
>
> Thank you for your hint.
>
> Besides, I would like to update all the name and address to "anonymous"
> and "unknown". Can it be done with the wizard ?
>
> Thanks
>
> "Andrew J. Kelly" < sqlmvpnooospam@shadh
awk.com> wrote in message
> news:%231e6jvziFHA.3336@tk2msftngp13.phx.gbl...
>
>
|
|
|
|