Fix field will not fit in record error when exporting to dbase


G

Guest

What do I need to alter in order to successfully export to dbaseIV when I get
a "Field will not fit in record" error?
 
Ad

Advertisements

M

M.L. Sco Scofield

The most likely cause is that your Access field is longer than your dBase
field. I.E. The Access text field size is 150 characters and the dBase text
field is only 149 characters.

If that's not it, post back.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
G

Guest

Thx for the response, but it doesn't seem like there's a way to design your
dbase file when you're exporting from access to dbase. It just creates all
the parameters for you, correct? I will check the exporting/importing
discussion groups to see if anything is posted there.

Jesse
 
M

M.L. Sco Scofield

Sorry about that. I was thinking more of an export into an existing table
instead of an export to a new, Access created table.

Although this article is not specifically for Access, this might be
something to look into.
http://support.microsoft.com/default.aspx?scid=kb;en-us;110601

Also, dBase has a 10 character field name limit and does not like spaces or
special characters.

Personally, I'd create the table in dBase, link it, and export the data with
an append query.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Ad

Advertisements

Joined
Dec 9, 2014
Messages
1
Reaction score
0
What do I need to alter in order to successfully export to dbaseIV when I get
a "Field will not fit in record" error?
I had the same issue. I had to size down all the text fields in my Access table to 127 characters. Then when Access creates the dbf, it can insert the records. I also cut all my field names to 10 characters and my table name to 8 characters, but you may not have to do that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top