Can you use external changing databases with Access 2003?

[hoteljen]

I need data from 3 external databases, with date variables being a
consideration. is there a way to set up access 2003 to pull timely or
historical data from them without having to enter every number?

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

You have some general options:

1) if the data in on your LAN, link to the tables in the external database

2) export the data from the other databases into a format that can be
imported into or read by Access.

To give you any specific help, we need a lot more detail of exctly what you
want to do and whatyou are having trouble with.

Were is the external data?

I need data from 3 external databases, with date variables being a
consideration. is there a way to set up access 2003 to pull timely or
historical data from them without having to enter every number?

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com

 

[hoteljen]

What I need to be able to do is compare the effectiveness of my website. The
information changes daily on the Urchin report (reports on hits, sessions,
pageviews) to monitor for "bad" links, pages, etc. & marketing
effectiveness. The information on our demographic tracking also changes
frequently depending upon season and marketing campaign. I need these
figures to justify expenditures and to see where & when we need to make
changes to our marketing strategies without having to enter data daily or
purchasing more, expensive software.

 

[Boyd Trimmell aka HiTechCoach via AccessMonster.co]

Are you wanting to do reporting on the web server's log files?

Is yes, then:

Are you hosting your own web server in house?

What web server are is your site using?

Do you have access to the raw log files on the web server?

What exactly are you wanting to store?

What I need to be able to do is compare the effectiveness of my website. The
information changes daily on the Urchin report (reports on hits, sessions,
pageviews) to monitor for "bad" links, pages, etc. & marketing
effectiveness. The information on our demographic tracking also changes
frequently depending upon season and marketing campaign. I need these
figures to justify expenditures and to see where & when we need to make
changes to our marketing strategies without having to enter data daily or
purchasing more, expensive software.

You have some general options:

[quoted text clipped - 11 lines]

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com