My computer has recently been upgraded to Access 2000. I work with numerous Access databases. Many of these databases are made by importing data from Excel. Reps and dealers email these Excel files. They are in various versions of Excel and have unknown formats. I am finding that with Access 2000, I am often losing data such as the leading 0 in east coast zip codes or territory numbers that don't import at all. Any suggestions on how to get around some of these problems. I have only been using Access about 6 months consistently so may just lack knowledge of Access. However, I did not seem to have these problems when I was using Access 97.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
importing different Excel versions into Access
- Thread starter itoldie
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question