Importing from Excel

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

Guest

I imported something from Excel that I think I had formatted correctly and for some reason it only
imported records where there was data in my "Comments" field. This is of type 'Memo'
and is not a required field in the table. I have the same number of fields and all of the other
data come through as they should. Why would this happen if it is not a required field? I changed
the column for the comments field from General to Text in Excel but it made no difference.
 
Daniel,

Access looks at the first six or so rows on each field
column and tries to determine what the proper property is
for the Access field. Formatting or reformatting the
field in Excel does not necessarily determine what access
should make the field as. Formatting in Excel, what I tell
people, is a visual format. The actual data still sits in
the cell especially if you receive the Excel file from
someone else. Make sure if there is a date field, it is
structured as a date. If you have text mixed in with
numeric values, sort the file to have the text up at the
top. If you can't sort due to data restaints because there
is text mixed throughout, place a " ' " in front of the
numeric value to make it a text value...ie. 123 =
numeric '123 = text. Access will interpret this astext
and format the field accordingly.
-----Original Message-----
I imported something from Excel that I think I had
formatted correctly and for some reason it only
imported records where there was data in my "Comments" field. This is of type 'Memo'
and is not a required field in the table. I have the same
number of fields and all of the other
data come through as they should. Why would this happen
if it is not a required field? I changed
the column for the comments field from General to Text in
Excel but it made no difference.
 
Back
Top