Export to DBase dbf

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am trying to convert an excel spreadsheet into a dbf
format.

When I tried this from excel (using Save AS), I found that
field contents and headers were being truncated, so
instead I have imported the spreadsheet into an Access
database.

Whenever I try to export to dbase I receive an
error 'Field will not fit in record'.

Any ideas would be gratefully appreciated!

Paul
 
In [email protected],
Paul said:
I am trying to convert an excel spreadsheet into a dbf
format.

When I tried this from excel (using Save AS), I found that
field contents and headers were being truncated,.....
Click to expand...

Hi Paul,

I do this procedure from time to time. It's important to widen all the
columns first so that they're sized to the maximum size of the data.
 
Thanks for the suggestion - but no luck I am afraid. I
used AutoFit to widen the columns, but got the same resul.

Once I have 'Saved As' the data appears ok - but if I
close and then reopen the created DBF file, one column
seems to be truncated to 22chars and another to 43! (the
other columns are only 3-8 chars in length and are all ok).
 
In [email protected],
Paul said:
Thanks for the suggestion - but no luck I am afraid.
Click to expand...

I've found that saving to a CSV file and importing into FoxPro is the most
foolproof way to import data, however, you have to make sure the numerical
fields aren't formatted with commas for the hundreds.
 
Back
Top