Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2126
  • Last Modified:

field will not fit in record

we still use Foxpro 2.0 as our main database app.

i sometimes get list thats in excel that needs to be imported into foxpro and i use Access to do so... when i try to export to a dbase IV i sometimes i get a message that says "field will not fit in record".

any feedback is greatly appreciated!
fieldwillnotfitinrecord.jpg
0
lsmtech
Asked:
lsmtech
2 Solutions
 
clarkscottCommented:
Sounds like you have a text field (in Foxpro) that isn't big enough for the data.  Make sure all your Access table fields (text fields) have the SAME character length (permitted number of characters) as the Foxpro table fields.

Scott C
0
 
lsmtechAuthor Commented:
this was my immediate thought... in foxpro 2.0 the largest field acepted is 256... to accomodate this i changed all my fields to 200 characters (in Access) before exporting, but i still get this message
0
 
clarkscottCommented:
How about number fields; integers, long, double, etc.  Perhaps this is an 'overflow' error.

Scott C
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
lsmtechAuthor Commented:
im not that savvy with access 2007 but its a simple table and all data types are text and each field has the same general information.. see image
fieldwillnotfitinrecord2.jpg
0
 
clarkscottCommented:
How many of these 200 character text fields are in a single record?
Scott C
0
 
Bill RossCommented:
Please post a sample of the source data.  I will take a look and help figuer it out if possible.
0
 
lsmtechAuthor Commented:
clarkscott - we use foxpro 2.0 and we have a total of 37 fields but users do not have access to all of them.  each field has different length, we use anywhere from 1 to 120 characters
112608---new-screen.jpg
0
 
lsmtechAuthor Commented:
billdenver - the original file was an excel sheet which i imported into Access... i then use Access to export into dbase file (dbase 5, dbase III, and dbase IV)... i tried all three with the same results.
test3.xls
0
 
clarkscottCommented:
I don't know the max size of a FoxPro record... but in access...
Number of characters in a record (excluding Memo and OLE Object fields) 2,000

37 * 120 characters could be too much.

Examine one of your 'problem' records and count the characters.

Scott C
0
 
lsmtechAuthor Commented:
clarkscott - thanks

but i think the issue is not with Foxpro as i am getting the error in Access, when im trying to export a table into a dbase file... thats when i get the error... see first image posted
0
 
clarkscottCommented:
I didn't see an issue with simply importing to access (except Access didn't like the last column name).
"Field will not fit into record".   This message makes me believe that one of your Excel cells has more than 255 characters - and these characters may be trailing spaces, or tabs.  You will have to determine which field(s) these/this is and prevent this from occuring.  You could  use the TRIM() function to remove these unwanted characters.

Scott C
0
 
lsmtechAuthor Commented:
no complete answer
0
 
Julio A. Garcia MiguelCommented:
Last night I found this problem. My son has to export a table from Access in .dbf format.
None oh his intents nor mine were succesful, until I observed that all the text fields in the access structure  were by default of 255 length.
I simply reduced all of them to 200, enough to store the largest text of the table.
That was all. So simple.
You must try it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now