I have an Excel spreadsheet in which every field is formatted as Text except 1 Currency & 1 number field. I've automated the importing of the spreadsheet using the .TransferSpreadsheet code. Occasionally, I get a Numeric Overflow error. For some reason, Access 2000 doesn't give any Import Error tables like our 97 did. Previously, the 2 fields it would have issues with were the SSN & Zip code fields which were formatted as Text in Excel, but Access sometimes tries to bring in a Double. Not quite sure how to fix this so any insight & help would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Numeric Overflow Error When Importing Excel into Access
- Thread starter laakins
- Start date
Similar threads
- Locked
- Question