troubleshooting Question

Export MS Access

Avatar of Richard Korts
Richard KortsFlag for United States of America asked on
Microsoft Access
22 Comments1 Solution626 ViewsLast Modified:

This question is related to Q_28310426.html.

I have exported a table using the techniques as described in Q_28310426.html. It works for MOST records in the table; about 1 out of 40 it fails & outputs 2 records (for one database record) instead of one.

I am attempting to show the individual record content with the attachments.

The Excel spreadsheet cust_10034.xls shows the first Access record that failes on export (to .txt file).

The Excel file exported_10034.xls is the two records exported from the single record in Access. I opened the .txt exported file & told Excel it was tab delimited.

I can provide other examples in this format or another; I can also show segments of the exported file in Notepad.

Why is this happening?

Join our community to see this answer!
Unlock 1 Answer and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros