How To Reduce Default Short Text Field Size

[VICTORE]

Hi. I'm trying to reduce the size of some text files being imported. Access defaults to a ShortText Field Size of 255. I went into "Object Designers" and changed Default TExt Field Size to 60, but when I import my text files, all text fields are still denoting to 255 integers? Anyone know why? Many thanks. Vic

[GinaWhipp]

Hmm, nope, that won't help. Your best bet is to create a Temp table providing the fields are always the same and import into that table and then push to to live table with the correct settings. Now, you couls just import into the live table but I just prefer Temp table first to check for errors.

[June7]

Your import creates table? Not import to existing table?

You aren't using object design to create table. The import operation has its own defaults.

[VICTORE]

Thanks, an arduous step to have to add, but might have to do it this way as I need to reduce txt size fields, otherwise >2gb when all done n dusted...I'll investigate how I reduce short txt fields in csv in the interim...

[VICTORE]

Hi. So in my import operation, you mean the CSV file? I would have thought as part of the Access Import Text Wizard I could change/reduce the size of the individual text fields being imported, but when I click on Advanced option for any field, I get a "Method 'Width' of object 'IImexGridColumn' failed" message? Odd...But thanks anyway, you've made me realise object design change isn't the solution, I'm pretty green at all this..

[GinaWhipp]

You need to set up the Temp table and then create the Import Specification to put the data in that table. That said I'm wondering about the size of the file if the 2g limit is a consern. Another note, it's not the size of the field that determines the size of the database. It is the data within those fields.