如何用程序来删除Excel数据库中的记录(100分)

  • 主题发起人 主题发起人 李学先
  • 开始时间 开始时间

李学先

Unregistered / Unconfirmed
GUEST, unregistred user!
我有一个Excel数据库,想用程序来删除其中的记录,大致方法如下:
Delete from [sheet1$]
可是不行,错误提示为:
It is not surpported for ISAM(Indexed Sequial Access Method 索引序列访问方法)

意思我想是:要想用上面的语句删除记录,则相应的数据库必须有索引,但是Excel没有索引
所以不能删除。
我不知道怎么办,请各位高手指教。
 
其中,我是通过ODBC连接的,我用它查询可以,可是就不能删除记录,真是怪了!
 
可以用COM方式来做的吧.
在应用程序中打开Excel,打开这样的一个文件,然后删除其中的一行.
至于你在用COM时采用何种方法,就随便你啦.
 
去www.net-wing.net/kangwei下个OfficePartner吧,我正在下呢,顺便把Turbopower的广告
给贴出来:
Introducing OfficePartner 1.6, the easy way to integrate your projects with Microsoft Office.
More than just a wrapper around Office's automation servers, OfficePartner is a complete object-oriented VCL framework that leverages the power inside Office applications like Excel, Word, Outlook, and PowerPoint. With OfficePartner you can access COM services in Microsoft Office with easy to use VCL components - even across the network!

Treat Office applications like the giant collection of services they are with OfficePartner, new from TurboPower Software Company.

TurboPower is pleased to announce that we have acquired OfficePartner from DeVries Data Systems. You can read the press release detailing this acquisition here.

Easy access to Office file formats
OfficePartner gives you easy access to standard Office document formats. Now you can easily extract data from Excel worksheets and Word documents with simple method calls. Plus, you can output your own data in any of these formats.

Save reports as Microsoft Word documents
Construct complete spreadsheets, complete with your own Excel charts
Export results as fully formatted PowerPoint presentations
Easy access to Office data
But OfficePartner does more than manage file formats. The OfficePartner hierarchy includes everything you need to use Office services without having to be a COM or Automation expert. Now you can think of Microsoft Office applications as giant toolboxes of functionality, just waiting for you to tap into!

Manage Outlook Folders, Contacts, Tasks, Appointments, and Notes
Use Excel's powerful charting engine to visual data in your own programs
Tap into Microsoft Outlook's Contacts database like it was any other VCL data source
Run PowerPoint presentations
Send e-mail messages through Microsoft Outlook
Open, manipulate, and print Office documents like Word documents and Excel worksheets
Easy to use (no COM expertise required!)
OfficePartner provides true point-and-click access to Microsoft Office 97 and 2000 applications. With OfficePartner, you'll deliver robust, custom solutions without having to master an in-depth knowledge of difficult COM or Automation techniques.

Leverage the power of Microsoft Office data visualization for your VCL datasets
Smoothly handle Microsoft Office automation events
Compatible with Borland Delphi 3 (and later) and
C++ Builder 3 (and later)
Automate Word mail merges with built-in support for VCL Datasets and ODBC
Powerful connection framework lets OfficePartner components attach to running instances of Office Applications and other OLE Containers
Distribute royalty-free with your application
Plenty of examples (for both Delphi and C++Builder)
Complete source code (written in Delphi)






Special introductory
pricing available
All-new printed manual
 
我的只能用TABLE,QUERY都不行.
 
多人接受答案了。
 
后退
顶部