store the data database to Excel.

[Jagbani]

Hi,

I want to store the Data database to Excel i have no idea, please you reply me how do store data database to Excel.

[deveshraigniit]

Then your best bet is ADO. Connect to excel using ADO, get all the data in the recordset and them isert the data from that recordset into Access table. Your connectionstring for excel would look like this
Code:

"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcelFile.xls;Defau ltDir=c:\myFolder;"

And you will use a simple query like this to create the recordset

PHP Code:

SELECT * FROM [SHEET1$]"