Importing

[jacobelias]

Hello,

I have data in SQL Server, which I import from excel sheet daily.

I want the data to be exported to MY Sql database either
from SQL Server or from excel sheet (which I use to insert into SQL Server). How can I perform this task by creating an admin module to get the data on a daily basis?

Any help would be appreciated.

Thanks

Jac

[bad76]

Hi,
An easy solution is to set-up an ODBC database from your excel sheet.

Then you can access it directly form php:

$srclink = odbc_connect ("database", "author", "***")
        	or die ("Error opening DB");

$Query = "SELECT * FROM table";

$queryexe = odbc_do($srclink, $Query)
		or die ("Error executing query");

while (odbc_fetch_row($queryexe)) 
{
    	$data="";
    	for($i=1; $i<$numoffield; $i++)
    		$data[] = "".@odbc_result($queryexe, $i);
    	echo $data[0]." ".$data[1]." ".$data[4]." ";
}

I hope this help you...