Odd field values on import of data

  • Thread starter floyd33 via AccessMonster.com
  • Start date
F

floyd33 via AccessMonster.com

I have a table, tblAttendee, that my users import to from an excel
spreadsheet. There are two fields, both text fields with a limit of 75
characters, that on import are showing the values to look like this: "2.
00502e+009." The values are typical number/letter combinations prior to
import but then turn into this. What could be causing this?
 
J

Jerry Whittle

Access has a bad habit of only looking at the first few lines of an Excel
worksheet then guessing the data type. In this case it's making it a number
and importing it in scientific notation.

Try this: Create a bogus record in the second line of the worksheet. In the
fields having problem, put just alphabetical characters like ABC. See if
everything imports properly after doing this.

If so, you may need to create a bogus record in Excel and delete in Access.

Another possibility is to link to Excel instead of importing it. Use an
append query based on the linked Excel worksheet.
 
Top