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

Populating Access from foreign system

P: n/a
Hi, I hope (expect!) this is straightforward - at this stage I need to
know the feasibility of this.

The scenario: a webserver running a database. A subset of the data (say
3 tables) needs to be loaded into an access database on a private serve
someplace else (private LAN).

My initial thoughts are:
- generate from webserver database .csv formatted files (incrementals)
- automatically ftp these to remote machine
- run some kind of import into access

Now in this scenario, we have complete control of the structure of the
access database so that shouldn't be an issue (i.e. we don't have to
conform to any proprietary design).

The idea is that all this should run unattended.

What is the best approach - setup the access database so that the
'tables' are mapped directly to .csv files?

Looking for a solution that would work access 2000 upwards.

Really appreciate any tips!

cheers

--

jeremy
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

My suggestion is this:

If you have control over what scripts runs on the the web server, you should
write one, which, receive a autentication data (like username and password),
and returns data to the browser.

It can be either formatted as a HTML table, or as a raw text file, like CVS.

Then in your Access application, you can use on a form either with Web
Browser ActiveX control, or with Microsoft Internet Transfer control. Both
of them allow you to open a connection to a URL resource to retrieve it.
This resource point to the page who contains the server side script which
returns data you need.

This way you can retrieve data from the web server to your local PC, save it
to a file then import it into Access database, all unattended (you can run
your form hidden and schedule your processing with a timer on that form).

Even further, you can make start your access application with task
scheduler, and after it finish the importing job, exit, so you don't even
need to have Access running all the time.

If you have any further questions, you can contact me.

HTH,
Bogdan
__________________________
Independent consultant


"Jeremy" <ne**********@hazelweb.co.uk> wrote in message
news:MP************************@news.individual.ne t...
Hi, I hope (expect!) this is straightforward - at this stage I need to
know the feasibility of this.

The scenario: a webserver running a database. A subset of the data (say
3 tables) needs to be loaded into an access database on a private serve
someplace else (private LAN).

My initial thoughts are:
- generate from webserver database .csv formatted files (incrementals)
- automatically ftp these to remote machine
- run some kind of import into access

Now in this scenario, we have complete control of the structure of the
access database so that shouldn't be an issue (i.e. we don't have to
conform to any proprietary design).

The idea is that all this should run unattended.

What is the best approach - setup the access database so that the
'tables' are mapped directly to .csv files?

Looking for a solution that would work access 2000 upwards.

Really appreciate any tips!

cheers

--

jeremy

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.