By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 1,989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

Can I use VBA to import/link tables?

P: n/a
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 stored
in the same location on my hard drive.

What I'm trying to do is download info from the web into the spreadsheet and
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 and
Excel is easy to work with. I suppose it might even be possible to download
right into Access?

Thanks in advance!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <dj****@hotmail.com> wrote in message
news:kQ*******************@newssvr25.news.prodigy. com...
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 stored
in the same location on my hard drive.

What I'm trying to do is download info from the web into the spreadsheet and 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 and Excel is easy to work with. I suppose it might even be possible to download right into Access?

Thanks in advance!

Nov 12 '05 #2

P: n/a
just what I was looking for - thanks!

"xzzy" <mr********@comcast.net> wrote in message
news:BWyDb.126188$_M.661228@attbi_s54...
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" <dj****@hotmail.com> wrote in message
news:kQ*******************@newssvr25.news.prodigy. com...
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 stored in the same location on my hard drive.

What I'm trying to do is download info from the web into the spreadsheet

and
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

and
Excel is easy to work with. I suppose it might even be possible to

download
right into Access?

Thanks in advance!


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.