title: Importing table from Postgres to MS Access and losing records
body: <p>I have a postgres table containing nearly 700,000 records, I import that table into MS access (via an ODBC data source) and end up with only 250,000 records.</p>
  
  <p>I start with an empty MS access database (520 kbytes). Select (external data)/(New data source)/(from other sources)/(ODBC database)/(Import the source data)/(Machine data source) I pick my ODBC postgres database, and select the table I want, wait for 30 seconds, then I get a message box saying all objects have been successfully imported followed by being asked if I want to save the import steps.</p>
  
  <p>There are no error messages, but the number of rows in my MS access version of the table is around 250,000. </p>
  
  <p>Other info...</p>
  
  <ul>
  <li>I'm using MS office 365 version 1710 </li>
  <li>I'm using postgres 9.5.7 </li>
  <li>I'm using the PostgrSQL ANSI ODBC driver (not sure which version)</li>
  <li>There are no signs of any error messages (or warnings).</li>
  <li>After the import the Access database is still only 375 Mbytes, well short of the 2 Gbyte limit.</li>
  <li>I've checked the 'ODBC data sources' app to check how the postgres ODBC link is configured, there's no obvious problem with it.</li>
  <li>The final message that MS access gives me after the import includes 'all objects imported without errors'</li>
  <li>There is no obvious difference between the records that are getting through and those that aren't.</li>
  </ul>
  
  <p>Why am I losing records, and what can I do to cure it?</p>
  
  <p>Thanks</p>