...it's me...eRiCk

it's kinda heptic here..there are 2 deadline project and the computer is in reinstall step :D alot of multitasking need to be prefomed :(..not sure wether it can complete or not updated: well everything is looks ok now..NEC project is on golive now, also other project looks fine :D..i'm so glad it can finish just need some finishing i'm gonna take a rest now, playing dota he he he

very22 hard to learn :(.. SELECT Q1.* FROM OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=PATH_TO_EXCEL_FILE;IMEX=1;HDR=Yes;', 'SELECT * FROM [SHEETNAME$]') AS Q1 Or SELECT Q1.* FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="PATH_TO_EXCEL_FILE";Extended properties=Excel 8.0;')...SHEETNAME$ AS Q1 GO