Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-30-2016, 02:22 PM   #16
radshar
Newly Registered User
 
Join Date: Aug 2016
Posts: 32
Thanks: 9
Thanked 0 Times in 0 Posts
radshar is on a distinguished road
Re: Logging Imports

Ok I might have done something wrong.

This what I have:
2 Tables
  • Daily_cumulative
  • tbl_Import
I have a button macro which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative.
tbl_Import should display for me the name (or path) of the file I just uploaded as well as date/time.

If I understand you correctly. I need to add the fields "FileSource" and "ImportDate" to the Daily_cumulative table, correct?
I tried this and still I get nothing...

I'm so sorry about this, but I am really an amateur at all this


Quote:
Originally Posted by pbaldy View Post
The method is intended to be used where the import will populate most of the fields, leaving this one Null. This query will populate that last field. For example, the second time you run the process, the previously imported records will have this field populated but the new records will not. The query given will thus populate the newly imported records leaving the older ones alone.

radshar is offline   Reply With Quote
Old 08-30-2016, 03:20 PM   #17
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,874
Thanks: 12
Thanked 4,033 Times in 3,970 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Logging Imports

Quote:
Originally Posted by radshar View Post
Ok I might have done something wrong.

This what I have:
2 Tables
  • Daily_cumulative
  • tbl_Import
I have a button macro which when pressed prompts me for the file I want to upload. The data is uploaded to Daily_cumulative.
tbl_Import should display for me the name (or path) of the file I just uploaded as well as date/time.

If I understand you correctly. I need to add the fields "FileSource" and "ImportDate" to the Daily_cumulative table, correct?
I tried this and still I get nothing...

I'm so sorry about this, but I am really an amateur at all this
You chose the method that uses those fields, yes. My first suggestion was more in line with your setup (executing an append query or using a recordset).

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
import , log , log import

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
saved Imports DaRTHY Macros 2 05-18-2015 06:03 AM
XML and XSD Imports GendoPose Tables 0 12-12-2014 05:17 AM
Saved Imports colvangerry Macros 1 06-22-2012 06:30 AM
Help with Imports.. pr2-eugin Tables 1 01-19-2012 05:52 AM
Bulk Imports Darth_Beckett Tables 3 01-10-2007 08:00 AM




All times are GMT -8. The time now is 02:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World