You down with ODBC? "Yeah you know me!"

[suttercain]

Hi guys,

 

I am still messing with getting an Excel spreadsheet over to MySQL. I am trying to display the data using ODBC. Here is the code:

 

<?php
error_reporting(E_ALL ^ E_NOTICE);

$cfg_dsn = "DRIVER=Microsoft Excel Driver (*.xls);
DBQ=C:/test.xls;
UserCommitSync=Yes;
Threads=3;
SafeTransactions=0;
PageTimeout=5;
MaxScanRows=8;
MaxBufferSize=2048;
DriverId=281;
DefaultDir=C:/ProgramFiles/CommonFiles/ODBC/DataSources";

$cfg_dsn_login = "";
$cfg_dsn_mdp = "";

$connection = odbc_connect($cfg_dsn,$cfg_dsn_login,$cfg_dsn_mdp);
$filename = 'test.xls';
$sheet = 'engine';
$cols = odbc_columns($connection, $filename, NULL, $sheet);
$query = "SELECT * FROM test.xls";
if ($query) echo 'Connected to ' .$filename. ''; //This does echo as hoped.

$queryexe = odbc_do($connection, $query);
if ($queryexe) echo 'Queryexe is true'; //This does echo as hoped.

while($row = odbc_fetch_row($queryexe)){
echo $row[1];
}
?>

 

I know the query and queryexe are both working because they echo as such. The problem I am running into is actually retrieving the data and displaying it. I tried to use a odbc_fetch_array and also the odbc_fetch_row and neither seem to be working as I had hoped.

 

Anyone have any ideas?

 

Thanks in advance.

 

SC