Gotta be an easier Way Question.....

[Torn39]

Hi Guys,

Please help. Gotta be a simplier way question....

Trying to write an append query from a table with about 270 fields. The problem is I only want 265 of the fields added to this other table, as the other 5 fields are not to be "passed" on to it.

The table with only 265 fields is to be exported to another program, and can

Right now I am copying and pasting my brains out trying to write the old fashioned version. Please tell me someone has a better way...

Okay, I just thought of a better way. I can copy the whole tabe then delete the 5 fields I don't want off it then pass it on...The dummy comes up with his own answer...

But is there another way?

Thanks,

Drew

 

[MichaelRed]

Some CONFUSION or Obfuscation here.

Ms. A. supports only 255 "fields" in a table, where "Fields" includes indicies.

So, 270, 265 ... Fields cannot refer to Ms. A. tables,

It is RARE that anyone in current relational db would come even close to the number of fields you mention. I've been using some form of relational db for ~~ 10 years, and the "widest" table I recall creating was probably 70 or so fields, and that was "cumbersome" to work with. I HAVE sliced/diced/chopped many larger tables created by my predecessors into smaller units - but even these were generally less than 200 fields.

So, try to re-state the 'problem' in terms which can be dealt with,


MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[Torn39]

Michael,

I apologize...there are only 233 fields/columns. I had already cut and paste about 100 of the names into the old fashioned method and I took a guess at it. So really I only want to move 228 of the fields into my "export" table from my 233 field "original" table.

I apologize again for my misstep. Thanks for your help.

Drew

 

[MichaelRed]

Still seems foolish to me. I would not consider having such a table. But, to export some part of it, I would suggest a simple select query and then transferspreadsheet of the resulting recordset. If you don't know how to do either (or both) of these, refer to the HELP system.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over