Database Discussion - Scheduled import between tables?

Print Page | Close Window

Scheduled import between tables?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8191
Printed Date: 30 March 2026 at 12:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Scheduled import between tables?

Posted By: niteperson
Subject: Scheduled import between tables?
Date Posted: 18 December 2003 at 10:14am

Hello all.

I need to schedule an overnight task to import some Timberline accounting data (ODBC datasource) into an Access database. I only need to import 4 or 5 tables, not the whole database, and need to schedule the import for midnight every night.

Is there software out there that does this? If not, is this relative easy to do myself?

Thanks in advance for any help.

Tony

Replies:

Posted By: michael
Date Posted: 18 December 2003 at 11:46am

Just write a macro in access that does your import and the put a command like:
c:\....\msaccess c:\db1.mdb /x macro1
into the windows task scheduler

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: niteperson
Date Posted: 18 December 2003 at 1:18pm

Can you recommend some resources that show how this is done?

Tony

Posted By: michael
Date Posted: 19 December 2003 at 7:22am

Well I just checked the help file on the syntax so you call msaccess.exe pathtomdb /x macroname
For the Macro itself you can do either a SQL statement or use under Action the Transfer Databse one. I am sure there are further instructions on msdn.com or so.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker