473,395 Members | 1,726 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Can I use VBA to import/link tables?

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
2 10054
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: davvid | last post by:
hello, please I would like to know if it's possible to load data in hierarchical table structure with identity column used as pk (for all the tables) : I mean table root (Id_root(pk,identity...
4
by: Steve Jorgensen | last post by:
I'm restarting this thread with a different focus. The project I'm working on now id coming along and will be made to work, and it's too late to start over with a new strategy. Still, I'm not...
3
by: David | last post by:
Hi, We a have a small office network of 3 users. Each user has their own copy of an MS Access Front-End which is linked via their own local ODBC connection to our server's MySQL database (Linux...
6
by: Noozer | last post by:
We've created a new database and need to import the data from our old database. Both are MS Access databases and each have multiple tables. The table structure of each table is completely different...
3
by: deko | last post by:
I've been trying to use the Access Import Wizard to expedite importing data into my mdb. The nice thing about the wizard is that I can import from different file formats - txt, xls, even Outlook -...
0
by: NYShai | last post by:
I am using Access to analyze data in a remote SQL server. I cannot "link" these tables, because Access doesn't like the SQL's replication ID, so I need to import these table each time I run a...
3
by: Tony | last post by:
With respect to the questions below, please assume that our database(s) and all text files are shared on a network file server. When opening a shared MDB, what is the effect of its accessing data...
11
by: kaisersose1995 | last post by:
Hi, I've got an import procedure working, using a standard import specification to import a .csv file into a temporary table. The problem i'm having is that i have 4 different sets of borrower...
7
by: Pete | last post by:
I need to import multiple tab delimited files for which I do not have the formats. All files have column headers in the the line. The files must be dynamic. The only common value is that the...
14
by: mfrsousa | last post by:
hi there, i have a huge large text file (350.000 lines) that i want to import to a MS Acccess Database, of course i don't want to use Access, but do it with C#. i already have tried the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.