If I link in something, and then want to move it to a local table or something, my append query has a criterion of "is not null" for some type of important field like a key or something.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, June 16, 2015 8:01 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Blank entries in my tables with Excel upload
I have a couple of "crosswalk" tables. For instance, the patron ID and an activity they performed. I am seeing blank entries show up. I suspect I am getting this when I upload new records from an Excel sheet.
1. How can I prevent this?
2. What should I do about the blank records? Delete them, leave them alone, something else?
Thanks
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar