Too many indexes on imported table

[Debbie Hatten]

I am trying to import a table from an AS400 database, but
I keep getting an error stating that there are too many
indexes in the table. Anyone know a workaround?

 

[Brian Camire]

You might try create a pass-through query in Access that selects the rows
and columns you want from the AS400 table, and then create an append query
that appends the results of the pass-through query into your destination
table.