Open Excel File with SQL Server 2005!!!

Hanen

Hello,


I have an excel file and I just need to open it using SQL Server 2005 and to save it.
Who can tell how to do that

Thanks a lot.

kine

You mean to import the excel file into SQL? SQL is server, you cannot "open" excel file with SQL... you can export/import data from excel to sql... can you be more specific, what you want to do? :-k

Hanen

I don't need to import or export Excel file, I just need to open the file, that's all.
Isn't there an open(filepath) or something like that????

DenSter

You open Excel files with Excel, not SQL Server.

kine

Hanen wrote:

I don't need to import or export Excel file, I just need to open the file, that's all.
Isn't there an open(filepath) or something like that????

Can you tell us why? Because for me it looks like some misunderstanding...

David_Singleton

Hanen wrote:

I don't need to import or export Excel file, I just need to open the file, that's all.
Isn't there an open(filepath) or something like that????

Then you can not do it. Its impossible to open an excel file with SQL. SQL is a server, it does not open things. Even if you meant SSRS it still is not possible.

If import is not acceptable to you then you are out of luck.

Why don't you just say what you want to do so that people can help you?

Hanen

I'm claling a Stored Procedure from Navision and the result is an Excel file.
I want the user to see the Excel File result just after runing the report without having to go to the path and open the file manually.
Thanks for help!!!

kine

Than you can open the excel from NAV, not from SQL...

Hanen

I'm trying that way, but do you know how to do that?? :oops: