MS Access (Extending table Limits)

[jonathanisaac]

I have a table which has 162 columns. I want to export the data into .txt file, but access does not support tables with columns more than 139 columns it gives the error "<Fieldname> contains start positions of 32769. the maximum start position allowed is 32767"

pls tell me how to over come this problem. I cannot remove any columns all are of great importance.[/b]

 

[Seti]

Could the 32767 be the maximum width of a text file that Access will create? I did a quick calc and 32767/139 (the number of columns you could get) gives an average width for each column of 235. If you have a lot of text coulmns, are they set at a width of 255? If so, do they need to be? Could you narrow some columns? Keep in mind that I am guessing to some degree here.

HTH

Seti

 

[Corticus]

Hi jonathanisaac,

I hate to say it, but it is very unlikely that you need more than 139 columns. Even if the data is important, I doubt that you have it organized correctly. Each column should be a field, and I can't see how one peice of information would have 162 different fields associated with it.

If you must have this many fields, split the table into two tables, and relate them one to one.

If you post some sample data, maybe we could see what's going on with all those fields.

HTH,