just what I was looking for - thanks!
"xzzy" <mrbikejoc1@comcast.net> wrote in message
news:BWyDb.126188$_M.661228@attbi_s54...[color=blue]
>
http://www.mvps.org/access/tables/tbl0009.htm
>
> and
>
>
http://www.4tops.com/ms_access_tips/rxltbl.htm
>
> should help you.
>
> John Bickmore
>
www.BicycleCam.com
>
www.Feed-Zone.com
>
> "deko" <dje422@hotmail.com> wrote in message
> news:kQxDb.71990$886.59754@newssvr25.news.prodigy. com...[color=green]
> > Rather than using
> >
> > File >> Get External Data >> Link Tables...
> >
> > I'm wondering if I can automate the linking process with VBA. The Excel
> > Spreadsheet I want to link to will always have the same name and be[/color][/color]
stored[color=blue][color=green]
> > in the same location on my hard drive.
> >
> > What I'm trying to do is download info from the web into the spreadsheet[/color]
> and[color=green]
> > periodically update my database with that information.
> >
> > Has anyone done this kind of thing before? The reason Excel is a good
> > intermediary is because the downloaded data usually needs to be massaged[/color]
> and[color=green]
> > Excel is easy to work with. I suppose it might even be possible to[/color]
> download[color=green]
> > right into Access?
> >
> > Thanks in advance!
> >
> >[/color]
>
>[/color]
