Displaying the actual data that error message is referring to

T

tishyouwish2006

Is there a way to display the actual records that are being imported
from excel to access if they continue giving you an error message?
 
K

KARL DEWEY

The way I do it is to temporarily add a Row field in the Access table, add a
new column in the Excel, autofill with =Row() and then copy-paste
special-values.

When it is imported i can compare what didn't.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Help creating a search form in Access XP 0
Internal Data Integrity (Type 4) Details Needed 1
Creating a Chart on form from selected data in query. 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
an error occurred while processing this directive 0
VBA - exporting serial letters to single documents 0

Top