Excel reader (DELPHI)

[SubFire]

You can do an nice program Quickly an effective !

Do the program in 6 Steps :

http://delphi.about.com/od/database/l/aa090903a.htm
*** LOOK CONNECTION STRING SECTION BELOW !

http://delphi.about.com/od/database/l/aa090903b.htm

http://delphi.about.com/od/database/l/aa090903c.htm

http://delphi.about.com/od/database/l/aa090903d.htm

http://delphi.about.com/od/database/l/aa090903e.htm

http://delphi.about.com/od/database/l/aa090903f.htm

DOWNLOAD : http://delphi.about.com/library/code/ncaa090903a.htm

Special Thank to :

http://delphi.about.com/


CONNECTION STRING :

For the connection string use this one to avoid problem :

Problem description :
http://delphi.about.com/od/database/l/aa090903d.htm

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

allow mix data type : IMEX=1

source : http://www.connectionstrings.com/?carrier=excel


EXCEL 2007 :

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0;HDR=YES";

Source : http://www.connectionstrings.com/?carrier=excel2007

Special thank to :

http://www.connectionstrings.com/