Solved

Export to DBF IV

Posted on 2004-04-15
4
1,409 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
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

856 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