Linking a Excel file to a Table

I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance
Check out linked servers in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:F5C27639-4876-4777-A019-211D06D1A29E@.microsoft.com...
I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance
sql

Linking a Excel file to a Table

I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advanceCheck out linked servers in the BOL.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:F5C27639-4876-4777-A019-211D06D1A29E@.microsoft.com...
I have an excel file that I need to copy a column from the file to update a
column in the SQL Table. Is this possible, if so, how I can accomplish this
task?
Thanks in advance

Linking 2 datasets?

Hi, is there anyway to link 2 datasets? What I want to accomplish is having
one datase where the categories group is fetched and another one where the
products are fetched, something like this:
Category A
- Product A
- Product B
- Product C
Category B
- Product F
- Product G
- Product H
I know I can use just one dataset and grouping the information on the table,
but just wanted to know if this can be done by having to 2 dataset and
having them linked somehow.
Your help will be appreciated.
Regards,
Fabian von RombergNo,
Have a look at sub-reports, this will do the same thing. Link the subreport
to the main report by a parameter.
"Fabian von Romberg" <fromberg100@.hotmail.com> wrote in message
news:eKV#6bbuFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Hi, is there anyway to link 2 datasets? What I want to accomplish is
having
> one datase where the categories group is fetched and another one where the
> products are fetched, something like this:
> Category A
> - Product A
> - Product B
> - Product C
> Category B
> - Product F
> - Product G
> - Product H
> I know I can use just one dataset and grouping the information on the
table,
> but just wanted to know if this can be done by having to 2 dataset and
> having them linked somehow.
> Your help will be appreciated.
> Regards,
> Fabian von Romberg
>