Does it create a paste errors local table where you can check it out?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of runuphillracing@yahoo.com
Sent: Thursday, January 09, 2014 10:03 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] acImport problems
Having trouble with TransferSpreadsheet. When I run the code, or manually do a File Import, it only imports 419 of the 433 records. However, when I copy from Excel and Paste Append in Access, all 433 records copy over fine. There doesn't seem to be anything different in the 14 records that it's skipping - same type of data in each field, text field lengths are shorter than the longest lengths in other records that import.
Help please.
Adam
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.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar