Export to DBase dbf

[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

 

[Cindy Winegarden]

In [email protected],

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,.....

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.

 

[Paul]

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).

 

[Cindy Winegarden]

In [email protected],

Thanks for the suggestion - but no luck I am afraid.

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.