Import frm Excel access won't convert text into a lookup field.

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

Guest

Trying to populate a new data base. Have created table. Have made sure
field names in access and excel are identical. Import to existing table
converts 0 records. Can import to new table but when appending to existing
table drops the text entries in lookup fields. Think this is because of
datatype discrepancy. How do I fix?
 
I have a few of suggestions. Assuming you have no data in your Access table
at this point:

1. Make a copy of the table you're trying to import data to, then try
changing the lookup field temporarily to a text box. Append the data to the
table copy, and change the problem field back to a lookup field. If that
works, then you can delete the original table and rename the copy. If it
doesn't, try removing every single data type restriction from the table copy,
and try the append again.

2. When you attempt to append data to an existing table, are you copying
and pasting the data or using an append query? If an append query, try
copying the data from the table you've imported it to. Open the table you
need to get the data into, place your cursor in the last row, and then use
the "Paste Append" option on the Edit menu to paste the data.

3. Change the data type of each column in the Excel spreadsheet to match the
restrictions you have in your Access table.

GwenH
Master MOS
 
Thanks much, was able later to copy and paste the offending fields from the
Excel linked table. Appears to be a one shot deal since I was able to copy
and paste only the full column. Again thanks for your reply
 
Back
Top