Dear Mr Boyce
Thank you so much again.
After I import, there is an error table produced indicating the error is due
to null value of the field where it is defined as autonumber
Does it mean I have to do append query to import the rows from excel file
instead?
Additionally, in the access table, there is a field that will record the
date & time of entry. When I import the excel file, should I leave that
column blank.
Sorry for my silly question. I am new to using access. I wonder if there
is any book or reference that I can go to help master the application better.
I ve tried the help section, but it does not really solve my problem
specifically.