Joseph
|
| Posted: 04/06/2002, 5:22 PM |
|
Does anybody have experience connecting CC to an Excel spread Sheet? I can obtain a connection in the database tab and it tests ok, but when I go to build a page I don't see any recordset.
Any help appreciated!!!
Joseph
|
|
|
 |
Amelie Poulain
|
| Posted: 04/08/2002, 3:53 AM |
|
Looks like it possible only to diplay data , not update.
What is "build page" ?
|
|
|
|
CodeCharge Support
|
| Posted: 04/08/2002, 5:20 AM |
|
Joseph,
to connect to Excel table with CodeCharge pleaes try to select in window 'Datalink properties':
'Microsoft JET4.0 OLE DB Provider' as Provider on Providers Tab
and select .xls file as Database Name on Connection Tab,
then go to All tab and double click on 'Extended properties' to input Property value. Use:
Excel 3.0 - Excel 3.0
Excel 4.0 - Excel 4.0
Excel 5.0/Excel 95 - Excel 5.0
Excel 97 - Excel 97
Excel 2000/Excel2002 - Excel 8.0
|
|
|
|
|
