Hi,

I'm not sure why you are exporting to a DBF file. In Access predefine the
table, hense controlling column width (field size). Then copy the data from
Excel directly into the table or import it using the File, Get External Data
command in Access. This step will be easiest if you name the data range in
Excel (with titles) and save the file before you start the import.

Access won't allow you to bring more characters in than each columns
predefined field sizes allow.


--
Thanks,
Shane Devenshire


"jerminski73" wrote:

I need to have a certain number of characters in a cell for the data to
import into my scanner. I am using a dbf to import the data to access. The
data all looks good but now I have to export it and have it all a certain
character length to work.... Field 1 6 characters, field 2 30, field 3 8,
field 4 8. I know there is a way to do this but cannot remember where I last
saw it done. Thanks in advance!!!!