send a web table to an excel sheet via odbc and sql

[sonyk]

Hello to all

 

Here is the headache:

 

I want to make a website. In this website there is a table with multiple columns and rows. The cells of the table are editable by the user on the web. After filling the cells with numbers, the user clicks a button and the table is sent to an existing (but blank) excel spreadsheet.

 

I have the website and i am trying to understand the code beneath this. This is for my graduation paperwork and the schedule is very tight.

 

If you can teach me how to this I would be most grateful:

 

How to make a php script that transfers all the data in a table to an excel sheet? I am using ODBC connection and sql language like this one:

 

<?php

$ligacao=odbc_pconnect("test","","") or die ("error");

$sql="INSERT INTO [sheet$](F1) VALUES ('value1')";

$resultado=odbc_exec($ligacao,$sql);

echo $resultado;

odbc_close($ligacao);

?>

 

Thank you a lot!