• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Populate data from one database to another database

Hi guys,

How do i populate data every month automatically from :
1 . excel spreadsheet to access/mysql/oracle
2. access/mysql/oracle to another access/mysql/oracle

thanks

0
crabbear
Asked:
crabbear
3 Solutions
 
nathanielIT ConsultantCommented:
To automatically run a program based on monthly (weekly or daily) schedule you should first setup a "scheduled task" program. You can do this by opening the scheduler program as follows:

Start->Programs->Accessories->System Tools=>Scheduled Task.

after experimenting on that, next is to develop an applications to automate the loading of excel data from access, mysql or oracle.



0
 
rockiroadsCommented:
How you can go about this is as follow

1) Use the command DoCmd.TransferSpreadsheet to import data from access into a access table
2) You could create a link to the table in the other database, then run queries to populate from your table to linked table

0
 
MayaPCommented:
you can also write a vbscript using ADO objects and FileSystemsObjects and put this script on a schedule as well.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now