没有AdoQuery的例子,给你个ole读取的例子吧 procedure TfrmCalDate.btnOpenClick(Sender: TObject); var ExcelApp:Variant; SheetCount: Integer; i, j: Integer; tmpStr: String; begin OpenDialog1.Execute ; if OpenDialog1.FileName = '' then Exit; ExcelFileName := OpenDialog1.FileName ; ExcelApp := CreateOleObject('Excel.Application'); ExcelApp.WorkBooks.Open(ExcelFileName); SheetCount := ExcelApp.WorkSheets.Count; lvSheet.Clear ; for i := 1 to SheetCount do begin lvSheet.Items.Add.Caption := ExcelApp.WorkSheets[I].Name; end; ExcelApp.WorkBooks.Close; ExcelApp.Quit; end;
procedure TfrmCalDate.btnOpenClick(Sender: TObject);
var
ExcelApp:Variant;
SheetCount: Integer;
i, j: Integer;
tmpStr: String;
begin
OpenDialog1.Execute ;
if OpenDialog1.FileName = '' then Exit;
ExcelFileName := OpenDialog1.FileName ; ExcelApp := CreateOleObject('Excel.Application');
ExcelApp.WorkBooks.Open(ExcelFileName);
SheetCount := ExcelApp.WorkSheets.Count;
lvSheet.Clear ;
for i := 1 to SheetCount do
begin
lvSheet.Items.Add.Caption := ExcelApp.WorkSheets[I].Name;
end; ExcelApp.WorkBooks.Close;
ExcelApp.Quit;
end;
ADOConnection1.GetTableNames(sl,true);
showmessage(sl.text);