Connect to Excel

[captphan]

I have an excel spread sheet that is changed weekly. I need to get this data into SQL or Crystal to generate a report.

I am new to SQL and am actually using SQL Server Management Studio Express.

When I lived in the tiny world of Access I could simply create a link to the Excel Spread sheet and am looking to do the equivalent here.

I am glad I don't know it all because then I would be bored

http://goallineblitz.com/game/signup.pl?ref=9436220

-Obie

 

[gmmastros]

You can create a linked server to an excel spreadsheet. Then you would use the 4 part naming convention to use it.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[captphan]

My issue is figuring out how to creat a linked server.


I am glad I don't know it all because then I would be bored.

http://goallineblitz.com/game/signup.pl?ref=9436220

-Obie

 

[gmmastros]

I encourage you to do a little research on [google]sp_addlinkedserver[/google].

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[captphan]

Thank you for pointing me in the correct direction.

I am glad I don't know it all because then I would be bored.

http://goallineblitz.com/game/signup.pl?ref=9436220

-Obie