Default Field Types/Lengths in Export Query

N

nickh

I have some calculated fields in a query. When I Export the Query to dBase,
those calculated fields (even math calculations the have a numeric result)
all default to a length 255 text field in the dBase file. How can I control
what the field type and length will be in the target dBase file?
 

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

Similar Threads

Split form 0
ACC2007: numeric fields truncated when imported from dBase III fil 1
Export to Excel - calculated field type conversion issue 0
Unreadable text when viewing organization chart in Web version of Visio 365 1
Format change in merge data - Bold formatting after a comma 0
Can't Export Table, Keep Getting Error Message 1
EXPORT QUery with memo field to excel, truncated data 2
ASK Field Formatting 1

Top