Setting text field size in query source when using TransferDatabas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a select query off of a linked table (cannot change destination
table properties) and using TransferDatabase to convert query to dBase 5.0
file. I am using Left function on a double to return left 8 characters.
Problem is, conversion sets this field to 255 characters, which expands the
output file by like 9 times what it could be.

I want to set the field size in the select query to keep this down to 50
characters. Is there a way to do this? I also notice this happens when using
Make Table, under various scenarios. I would then have to go in and modify
the table manually or write code to change these sizes. Would be nice to take
care of setting the size of the text field within the query.

Using Access 2003.

Thanks,
Clint
 
You can create and save an Import Spec to dictate the size of the fields.
Do a File / G. E. D. / Import. When the wizard pops up, click the advanced
button.

I typically import the data into an existing table. This affords me the
ability to have the table structure as I need it. Or import the table, then
perform an Append Query to a table of which the structure is set.
 
Back
Top