Sync web ical with access
- Thread starter mafhobb
- Start date
In general, yes. The iCal format is just plain text and you certainly can read and write that from Access.
However, "on the web" is a very vague specification. There are lots of different APIs and protocols to read/write data "on the web".
However, "on the web" is a very vague specification. There are lots of different APIs and protocols to read/write data "on the web".
Hello Sonic 8.
I basically have a Homeaway calendar where Homeaway guests add reservations. I can synchronize this Homeaway calendar with AirBnb by simply sharing the calendar link (http://www.homeaway.co.uk/icalendar/5f5e24d025574d1d8e96b46185387b942.ics)
I have another, similar link to sync the AirBnb icalendar with Homeaway, which indicates to me that both of these link are really only a one-way sync.
I am trying to do the same thing with Access. As a first step, simply being able to see/read this icalendar data in an access form would be great. As a second step, interacting with it (extract data from it, add data to it, edit data on it) would be ideal.
However I really do not know how to bring this icalendar into an Access form, much less interact with the data.
Any suggestion?
mafhobb
I basically have a Homeaway calendar where Homeaway guests add reservations. I can synchronize this Homeaway calendar with AirBnb by simply sharing the calendar link (http://www.homeaway.co.uk/icalendar/5f5e24d025574d1d8e96b46185387b942.ics)
I have another, similar link to sync the AirBnb icalendar with Homeaway, which indicates to me that both of these link are really only a one-way sync.
I am trying to do the same thing with Access. As a first step, simply being able to see/read this icalendar data in an access form would be great. As a second step, interacting with it (extract data from it, add data to it, edit data on it) would be ideal.
However I really do not know how to bring this icalendar into an Access form, much less interact with the data.
Any suggestion?
mafhobb
- Local time
- Today, 14:22
- Joined
- Feb 28, 2001
- Messages
- 30,162
Since Access itself doesn't actually HAVE an internal calendar format, the problem is to define where you would store the downloaded information. Outlook DOES have an internal calendar and Access (using an Outlook Application Object) can interact with it on your local machine or in any other .PST file to which you have permissions to read/write.
Access keeps dates as isolated data elements. If you build a calendar in Access, internally it would just be some sort of recordset (in tables). You would define your own structure for such a thing.
It is your app, so I won't choose a way for you. But your choices are either to use Outlook calendars as a repository or to build some data layout in a table to make your own calendar. Either way will have its complexities.
IF you choose Outlook, you will need to research how Access deals with Application Objects and in particular, Outlook objects.
If you "roll your own" then you have to design a method of data layout that will give you the level of interaction that you need for your purposes.
Access keeps dates as isolated data elements. If you build a calendar in Access, internally it would just be some sort of recordset (in tables). You would define your own structure for such a thing.
It is your app, so I won't choose a way for you. But your choices are either to use Outlook calendars as a repository or to build some data layout in a table to make your own calendar. Either way will have its complexities.
IF you choose Outlook, you will need to research how Access deals with Application Objects and in particular, Outlook objects.
If you "roll your own" then you have to design a method of data layout that will give you the level of interaction that you need for your purposes.
Similar threads
