Importing Excell

Looking for a way to import Excell with mulitple worksheets.
1. table that it is going into needs to have an additional column which is
automatically populated with the name of excell file
2. the other table it is going to needs to have an additonal column which is
to be automatically populated with the name of the worksheet.
Help. Thanks
--
HarryTry my column at:
http://www.sqlservercentral.com/col...ngxpexcelxmland
openxmlfordataimports.asp
"Harry" <harry.shambaugh@.sprint.com> wrote in message
news:D6342430-B70A-4B25-9DDD-89CFBEBA482A@.microsoft.com...
> Looking for a way to import Excell with mulitple worksheets.
> 1. table that it is going into needs to have an additional column which is
> automatically populated with the name of excell file
> 2. the other table it is going to needs to have an additonal column which
is
> to be automatically populated with the name of the worksheet.
> Help. Thanks
> --
> Harry|||The link provided is dead.
I have signed up for an account and retried...same results.
Do you have the path?
--
Harry
"sloan" wrote:

> Try my column at:
> [url]http://www.sqlservercentral.com/columnists/sholliday/leveragingxpexcelxmland[/ur
l]
> openxmlfordataimports.asp
>
>
> "Harry" <harry.shambaugh@.sprint.com> wrote in message
> news:D6342430-B70A-4B25-9DDD-89CFBEBA482A@.microsoft.com...
> is
>
>|||The article is there - the link wrapped around the line.
http://www.sqlservercentral.com/col...dataimports.asp
If that link comes up wrong, go to http://www.sqlservercentral.com and do a
site search for: "OPENXML for Data Imports". The article is the first link
in the list of results.
"Harry" <harry.shambaugh@.sprint.com> wrote in message
news:D861EC08-9602-45F4-8962-756FAFE14DDA@.microsoft.com...
> The link provided is dead.
> I have signed up for an account and retried...same results.
> Do you have the path?
> --
> Harry
>