Maximum size for exporting a table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • suet
    New Member
    • Nov 2011
    • 9
    #1

    Maximum size for exporting a table

    Is there a maximum size of the table that can be exported from Access to a text file? I have a table with a length of 519. After exported the table to text, the content seems to be truncated. Can someone provide me a suggestion?
    Thanks.
    Last edited by Stewart Ross; Nov 30 '11, 08:36 PM. Reason: Moved to a separate thread - please do not post in an old thread (one dating from 2006 in your case)
    Tags: None
    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32656
      #2
      I assume you mean the length of a record in the table. How do you know what that is? That info wouldn't generally be available without some fairly involved calculations.

      If you are referring to a single text field, then there are some scenarios where such data gets truncated. Memo fields are even more exposed to such truncations but it may help the question if we knew what it was. What are you actually dealing with?

        Comment

        Previous template Next
        Working...