Make Table Query

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

Guest

Hi,

I used the make table query to move the fields from all the tables into 1
table.Since I have more than 255 fields ,it gives me an error saying its too
many fields defined or the query is complex.Is there any way that I can get
this done in access?
Please help asap.
Thanks.
 
Niki,

What you are trying to do is almost certainly not valid from a database
point of view. Can you please post back with some more details,
including examples of your existing tables and what the fields are, and
say a bit more about what the combined table is supposed to look like.
Someone will be ale to advise on a good approach.
 
Back
Top