Importing Data into Table with Lookups

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I'm having difficulty importing data from an Excel
spreadsheet into a Table that consists of several lookup
fields.

I have seen other posts and Access Websites that are
against lookup fields on the Tables. Is there a way
around using Lookups at the table level and still have
lookups on the forms linked to the same 'non-lookup' field
at the table level?

Please help.
Thanks,
Frank
 
The Second Commandment of Access (per the Access MVPs website) is

"Thou shalt never allow thy users to see or edit tables directly but only through forms and thou shalt abhor the use of 'LookUp Fields' which art the creation of the Evil One.

What this means is since your users never see the actual tables there is no reason to be tempted to the Dark Side by LookUp Fields. ComboBoxes are a wonderous creation of the Good One and will serve you well on your data-entry forms. ComboBoxes ... and building good database Relationships to enforce data integrity

Hope this helps

Howard Brod


----- Frank wrote: ----

I'm having difficulty importing data from an Excel spreadsheet into a Table that consists of several lookup fields

I have seen other posts and Access Websites that are against lookup fields on the Tables. Is there a way around using Lookups at the table level and still have
lookups on the forms linked to the same 'non-lookup' field at the table level

Please help
Thanks
Fran
 
Back
Top