Solved

Export to DBF IV

Posted on 2004-04-15
4
1,414 Views
Last Modified: 2012-06-27
I have a table that I want to export to a dbf IV.  I go to export and select dbase IV and try to export.  I get an error that says "Record is too large".  I'm not sure what to do to correct this.  What do I need to do to get the table to export?
0
Comment
Question by:andymacd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 10835635
I'm afraid the record is too large as it can have too many fields or a field with too many data.
Is there perhaps a memofield in the table ?

Nic;o)
0
 

Author Comment

by:andymacd
ID: 10836247
No memo fields are present.  The data is in text format and Number format.  The numbers are doubles.  What size is too large for a dbf?
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 500 total points
ID: 10836734
0
 
LVL 28

Expert Comment

by:burrcm
ID: 10841964
Do make sure that your field names are not longer than 8 characters and do not contain spaces.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question