Not all data is importing into access file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing excel files into an access database (someone else created) and
some of the information is not importing into the access file. Rows of
information in excel are not showing up in access-where the row above and
below do show up.
 
Hi.

Check to ensure that the contents of the missing record aren't crammed into
the last cell of the record that comes before it in the Excel spreadsheet.
This can sometimes happen when an end-of-line (EOL) indicator is missing, so
that the contents of the next record become appended to the end of the
previous record, which messes up the import.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top