Introduction to synchronizing with Excel tutorial

This tutorial guides you through the basic steps for using direct row handling to synchronize data in a Microsoft Excel spreadsheet with MobiLink clients. This tutorial uses a Java implementation as an example.

This tutorial shows you how to implement MobiLink direct row handling so that you can use a data source other than a supported consolidated database.

You can use direct row handling to communicate remote data to any central data source, application, or web service.

For more information about direct row handling, see Direct row handling.

This tutorial shows you how to synchronize data in a Microsoft Excel spreadsheet to remote clients.

Required software
  • SQL Anywhere 11

  • Java Software Development Kit

  • Microsoft Excel 2000 or later

Competencies and experience

You require:

  • Familiarity with Java

  • Familiarity with Microsoft Excel

  • Basic knowledge of MobiLink event scripts and MobiLink synchronization

Goals

You gain competence and familiarity with:

  • The MobiLink server API for Java

  • Creating methods for MobiLink direct row handling

  • Accessing data from a Microsoft Excel worksheet using Java

Suggested background reading

MobiLink code exchange samples are located at [external link] http://www.sybase.com/detail?id=1058600#319.

You can post questions on the MobiLink newsgroup: [external link] sybase.public.sqlanywhere.mobilink.