I am learning how to use Access. I have some large sets of data that I am importing from Excel and I am figuring out how to turn a flat database into a relational database (which is a very new concept to me and I am trying to get my head around it).
So I import data as a flat database and then I run the wizard to turn it into a relational database...
The thing that is bugging me is I get to a stage where Access wants to correct typographical errors. It gives me the option of making a change or selecting "Leave as is". The trouble is I don't want to correct any typographical errors. Access thinks it sees errors when there are none... BUT it flags hundreds of errors and I can't find away to "Leave as is" for all of these in one go. Instead I have to select "Leave as is" for each record in turn. This is very time consuming. Does anyone know what I am talking about and is there an easier way? I am using Access 2010 (which I think is pretty much the same as Access 2007).