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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"floyd33 via AccessMonster.com" wrote:
> 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?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ldata/201005/1
>
> .
>
Similar Threads
