Re: Defining Text field sizes in destination Make-Table Query
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 11 Dec 2008 12:13:10 -0700
On Thu, 11 Dec 2008 10:43:00 -0800, JASelep <jaselep@xxxxxxxxxxx> wrote:
when extracting fields from ODBC DB2 tables into access using Make-Table Query
howdoes one define/limit the destination text field size?
Access seems to default to 255 or 50 characters which is problematic on
large numbers of records when the field only needs to be 3 to 10 characters
Keeping blowing 2GB limit because of all the dead space.
I'm unsure of how to trim / exclude / limit during the Maketable query process
You can't.
However, Access does not store trailing blanks. A 255-byte field containing
"XYZ" takes up 3 bytes (if you have Unicode compression on, which is the
default).
You can get a lot more control over your table structure if you avoid
MakeTable queries entirely, and use Append queries into a pre-built table
instead. Are you routinely importing the same kind of data, or is it a
different table every time? Have you been Compacting the database routinely?
That's essential if you are adding and deleting data (whether by deleting
tables or just deleting the data in the tables).
--
John W. Vinson [MVP]
.
- Follow-Ups:
- References:
- Prev by Date: Parameters
- Next by Date: sort by last name
- Previous by thread: Defining Text field sizes in destination Make-Table Query
- Next by thread: Re: Defining Text field sizes in destination Make-Table Query
- Index(es):
Relevant Pages
|
