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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top