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

*~ Export table 3 times daily with unique names!*~

P: n/a
Hi guys

I have this mini project that I could surely use some advice with.
Any assitance will be appreciated

Quick summary:
Need to export one table created in Access 2k in a new database that
will repeat
3 times a day. This procedure should be saved with the date and time in
the file name

Wish list:
Eventually these reports will be categorize by the week in a folder.
Week 1 - reports from May 1- 8
Week 2 - reports from May 9- 15
etc,etc

Software:
Microsoft Access preferred... but using VB is okay

Detailed info
Original database- Northwind.mdb
Table - TblTime
Tbltime needs to be transferred in a new datbase called Newtime.mdb

This is what I have so far in Marco

Action - Transferdatabase

Under Transferdatabase
Database Name - C:\Documents and Settings\Newtime.mdb
Destination - Monday > this is hardcoded but wont work as it replaces

the previous data on each run

Any help will be appreciated
thanks

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 9 May 2005 06:01:53 -0700, "cant_belto" <ls*******@gmail.com> wrote:
Hi guys

I have this mini project that I could surely use some advice with.
Any assitance will be appreciated

Quick summary:
Need to export one table created in Access 2k in a new database that
will repeat
3 times a day. This procedure should be saved with the date and time in
the file name

Wish list:
Eventually these reports will be categorize by the week in a folder.
Week 1 - reports from May 1- 8
Week 2 - reports from May 9- 15
etc,etc

Software:
Microsoft Access preferred... but using VB is okay

Detailed info
Original database- Northwind.mdb
Table - TblTime
Tbltime needs to be transferred in a new datbase called Newtime.mdb

This is what I have so far in Marco

Action - Transferdatabase

Under Transferdatabase
Database Name - C:\Documents and Settings\Newtime.mdb
Destination - Monday > this is hardcoded but wont work as it replaces

the previous data on each run

Any help will be appreciated
thanks

Destination - ="tbl " & (Format(Date(),"Dddd Mmmm dd yyyy")) &" " &
(Format(Time(),"h:n:s AM/PM")))

Becomes: tbl Monday May 9 2005 3:26:31 PM

Chuck
Nov 13 '05 #2

P: n/a
On 9 May 2005 06:01:53 -0700, "cant_belto" <ls*******@gmail.com> wrote:
Hi guys

I have this mini project that I could surely use some advice with.
Any assitance will be appreciated

Quick summary:
Need to export one table created in Access 2k in a new database that
will repeat
3 times a day. This procedure should be saved with the date and time in
the file name

Wish list:
Eventually these reports will be categorize by the week in a folder.
Week 1 - reports from May 1- 8
Week 2 - reports from May 9- 15
etc,etc

Software:
Microsoft Access preferred... but using VB is okay

Detailed info
Original database- Northwind.mdb
Table - TblTime
Tbltime needs to be transferred in a new datbase called Newtime.mdb

This is what I have so far in Marco

Action - Transferdatabase

Under Transferdatabase
Database Name - C:\Documents and Settings\Newtime.mdb
Destination - Monday > this is hardcoded but wont work as it replaces

the previous data on each run

Any help will be appreciated
thanks

There has *got* to be a better way to accomplish your requirements.

Chuck
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.