hello everyone.
i have a problem, my requirement is that i have an excel file and i want to import that file to my access database.

the code as below:
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
    "Data Source=" + Server.MapPath(path) ;
OleDbDataAdapter myCommand =
new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);

DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView; DataGrid1.DataBind();

but it is giving me error like
Unrecognized database format 'c:\inetpub\wwwroot\IDF\db\Book1.xls'.

wat to do...? pl help me out.its urgent

any help will be appreciated.

Komila :(

__________________
Komila Kalia
Software Developer
Reliance engineering Associates (P) Ltd.

Have you tried to use an XLS driver as opposed to the OLE driver?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.

Unless, of course, you want to hire me to do work for you.

you can use SQL Server MMC ,help to import the data

thanks dparsons for ur reply.
no i have not used an xls driver..n i even don knw that driver.
will search it on net.
but if u have then can u pl send that driver.
hope my problem get solved with that.
thnks again.

The driver should be on the server, you need to change your connection string to something like this:

Provider=MSDASQL; Driver={Microsoft Excel Driver (*.xls)}; DBQ=C:\path\filename.xls;

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

thnks again dparsons but u knw wat....i m gettng a big error.....after using that.
i have used connection string like below:
OdbcConnection cn_excel=new OdbcConnection("Provider=MSDASQL; Driver={Microsoft Excel Driver (*.xls)}; DBQ=C:\test.xls");

hey i have to download some file if yes then which....plz help.....

What is the error?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

hi dparsons.
thnks for helping. but with oledb.jet provider only my problem get solved.

code is as below.
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                                "Data Source=" + Server.MapPath(path) + ";" +
                                "Extended Properties=Excel 8.0;";

with the addition of last line problem get solvd i think.

thnks again.