Linking to an Excel Spreadsheet

Root > 3. Customisation

Linking to an Excel Spreadsheet


First, edit the NavBar.html and remove the comment-
<!--  Example of using the MS Access database integration example in a list format
and the following-
-->
 
Edit AdminLink.html and remove the comments there-
<!-- Remove this line to see the Admin link in the side bar
and
Remove this line to see the Admin link in the side bar  -->
 
Create a new .xls spreadsheet (empty) and save it in the WC root folder.
 
Open the WC site and use the new "Admin" link on the sidebar.
 
In the Admin screen, go to Database Aliases>DB1.
Select the Alias Type as "MS Excel" and save.
 
You can now browse to the new Excel spreadsheet in the WC folder and select it. Hit Save again.
 
Select "Show Tables" and "New Table"
Give the new table a name (let's call it Boats as an example) and make it a Contact List Detail Table. Save again.
 
Click on the new table and add 3 fields as VARCHAR fields (let's call them Make, Model, Year). You can add dropdowns if you wish.
 
Edit dbList.html and change the <#TABLE value= to <#TABLE value=Boats.
Change the <#LABEL field= and <#FIELDfield=tags to field=Make, field=Model, and field=Year.
 
Edit dbPage.html and change the <#TABLE value= to <#TABLE value=Boats.
Change the <#LABEL field= and <#FIELDfield=tags to field=Make, field=Model, and field=Year.
 
You should now have a one-to-many link to an Excel spreadsheet. The same steps and principles apply to link an Access table. You can use this new spreadsheet and the admin link as an example to create custom links.


Regional details are also available at http://www.wiredcontact.co.uk

Add Feedback