在SQLServer中执行 SELECT * into tablename FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="e:\database";User ID=Admin;Password=;Extended properties=dBase 5.0')...tablename 把Excel导入到Access中,同txt类似 select * into <table name> from [excel 8.0;database=<filename>].[<sheetname>$]
我也想知道 建议你用往access里存入图象的方法去操作excel试试 只改一下数据源设置试试行不行 var strfile:string; B:TBitmap; begin if OpenPictureDialog1.Execute then begin adotable1.Edit; B := TBitmap.Create; strfile:=OpenPictureDialog1.FileName; B.LoadFromFile(strfile); DBImage1.Picture.Assign(B); adotable1.fields[12].assign(B); adotable1.Post; B.Free; end;
SELECT * into tablename
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="e:\database";User ID=Admin;Password=;Extended properties=dBase 5.0')...tablename
把Excel导入到Access中,同txt类似
select * into <table name> from [excel 8.0;database=<filename>].[<sheetname>$]
建议你用往access里存入图象的方法去操作excel试试
只改一下数据源设置试试行不行
var
strfile:string;
B:TBitmap;
begin
if OpenPictureDialog1.Execute then begin
adotable1.Edit;
B := TBitmap.Create;
strfile:=OpenPictureDialog1.FileName;
B.LoadFromFile(strfile);
DBImage1.Picture.Assign(B);
adotable1.fields[12].assign(B);
adotable1.Post;
B.Free;
end;