I am trying to link a table to Access. The problem is the base table has the same field name listed twice(_17). I cannot change the base table so I would like to link the table but only link certain fields. Ideally, I would like to limit the results to a preset criteria in order to avoid writing a query to make a subsetted table.
I have had to import the table to Excel, eliminate the column and then import the revised table into Access. Is there a way around this and still be able to just link the table?
I have had to import the table to Excel, eliminate the column and then import the revised table into Access. Is there a way around this and still be able to just link the table?