• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2084
  • 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
  • 6
  • 5
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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