To import data into Access:

  1. Right click on the file (e.g. Client) and choose Save As... and save it on your Desktop.
  2. In Access, click the External Data tab, and in the Import section, choose Text File.
  3. Click Browse, and choose the file you just saved on your Desktop. Select the "Append a copy of the records to the table" option, and make sure the right table is selected (e.g. Client). Click Ok.
  4. Click Next, Next, and Finish. It might give some errors about dropping data - that's because some of the primary keys might be duplicated, so it ignores them, which is OK.