Guest
|
| Posted: 04/13/2004, 9:31 PM |
|
How can I use exel database in CodeCharge
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 04/13/2004, 11:15 PM |
|
I believe that Excel doesn't support the standard SQL syntax and doesn't work well in multi-user environment. You can create Web pages that display data from Excel, but you will not be able to update and delete the data (it will be read-only).
To use CCS to display Excel data on the Web you can create the standard System ODBC/DSN connection on your computer that utilizes the Excel ODBC driver, then use it in CCS.
Or you can use the JET driver by specifying the following connection string in CCS Connection settings:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\File.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1' (replace C:\File.xls with the real file name and assign IUSR permissions to the folder where the Excel is located)
The main difference between using the ODBC and JET drivers is that when using ODBC you will need to create named ranges in your Excel worksheet. The JET connection doesn't require named ranges and may work better anyway.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Guest
|
| Posted: 04/13/2004, 11:22 PM |
|
This is OK now. Thank you very much.
|
|
|
|
Guest
|
| Posted: 04/13/2004, 11:43 PM |
|
Just another little problem: In Excel File, I use Unicode, and I can't see what I want to write, ex: ?ng Di?m. How can I use unicode?Thnx
|
|
|
|
peterr
Posts: 5971
|
| Posted: 04/14/2004, 12:12 AM |
|
I don't know how to use Unicode in Excel, but for example I tried to copy some text in Russian and Chinese from various Websites and pasting it into Excel, then the Excel displayed this text correctly. An ASP application created with CCS also correctly displayed the grid that contains such text. I didn't see any problems.
BTW, are you asking how to enter Unicode text into Excel, or how to display on the Web the Unicode text already stored in Excel?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
BlinkyBill
Posts: 86
|
| Posted: 04/14/2004, 12:34 AM |
|
Quote Guest:
How can I use exel database in CodeCharge
Excel and Database are mutually exclusive 
|
|
|
|
DonB
|
| Posted: 04/14/2004, 5:44 AM |
|
Here's some info to help you get started.
http://support.microsoft.com/default.aspx?scid=kb;[LN];178717
If you search further at the above site, you should find tons of related
info. Likwise at http://msdn.microsoft.com
--
DonB
http://www.gotodon.com/ccbth
"Guest" <Guest@forum.codecharge> wrote in message
news:6407cbe91e9cf7@news.codecharge.com...
> How can I use exel database in CodeCharge
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
mme ngosso elisa
|
| Posted: 05/10/2004, 7:22 AM |
|
I will like to now how to use Excel properly
Receive all my sincere greetings.
Elisa
|
|
|
|
Visitor
|
| Posted: 06/30/2004, 9:07 AM |
|
But what if the Excel file is protected by the password to open, the password to modify or both of them?
I really need your kind help.
Thanks.
|
|
|
|
