投稿日 | : 2006/12/22(Fri) 11:11 |
投稿者 | : 魔界の仮面弁士 |
Eメール | : |
URL | : |
タイトル | : Re: DAOでのExcelのデータ取得について |
DAO を使わず、そのまま Excel オートメーションだけで読み取ればよいのでは?
> DAOでの取得を考え実行してみたのですが、
> 「3161 ファイルを解読できませんでした。」
その点は、Excel I-ISAM の制限となっています。
[Working with Microsoft Excel Worksheets and Workbooks]
| The Microsoft Excel product line includes the following
| single-sheet worksheet and multiple-sheet workbook versions
| supported by the Microsoft Jet IISAM driver for Microsoft Excel:
| Microsoft Excel 3.0 and 4.0 (single-sheet) and Microsoft Excel
| 5.0, 7.0, and 8.0 (multiple-sheet workbooks). There are a few
| operations that you cannot perform on Microsoft Excel worksheets
| or workbooks through the Microsoft Excel IISAM driver:
| * You cannot delete rows from Microsoft Excel worksheets or
| workbooks.
| * You can clear data from individual cells in a worksheet, but
| you cannot modify or clear cells that contain formulas.
| * You cannot create indexes on Microsoft Excel worksheets or
| workbooks.
| * You cannot read encrypted data through the Microsoft Excel
| IISAM driver. The PWD argument in the connection string cannot
| be used to open an encrypted worksheet or workbook, even if
| you supply the correct password. You must decrypt all
| Microsoft Excel worksheets or workbooks through the Microsoft
| Excel user interface if you plan to link or open them in your
| Microsoft Jet database.