如何将CSV文件的数据导入到ACESS数据库中

Question

有哪位大侠知道啊,告知一下,谢谢!

Answer 1

http://dev.cbw.com/cbuilder/database/20055245504_3504738.shtml

Answer 2

我把代码发上来,大家帮我看看
if OpenDialog1.Execute then
  begin
    sql:='select * from [Text;FMT=Delimited;HDR=Yes;DATABASE="'+ExtractFilePath(OpenDialog1.FileName)+'";].['+StringReplace(ExtractFileName(OpenDialog1.FileName),ExtractFileExt(OpenDialog1.FileName),'',[rfReplaceAll])+'#csv]';
    Query1.SQL.Add(sql);
    Query1.Open ;
    if Query1.RecordCount>0 then
      ShowMessage('OK');
  end;