>I am trying to pull a spreadsheet from Excel into VFP using a class I built based upon Sweet Potato Software's freeware. No matter what I do, the first row is ignored. The ODBC statement is below: (m.lcHeaderRow = "No")
>
>
> m.lnSQL = Sqlstringconnect("Provider=MSDASQL.1;" ;
> +"Persist Security Info=False;" ;
> +"DSN=Excel Files;" ;
> +"DBQ="+Fullpath(m.tcXLSFile)+";" ;
> +"DriverId=790;" ;
> +"MaxBufferSize=2048;" ;
> +"PageTimeout=5;" ;
> + m.lcHeaderRow)
>
http://support.microsoft.com/kb/288343
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up