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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I Break the 65000 Excel import barrier?
All, At work, we run audits in Access on Class V switch records that are sent to us in .txt files and daily we encounter files that contain between 300,000 and 1 million records. Since the telephone numbers are stored as Numbers and not Text some TNs don't have all their zeros. For example, TN...- talboyd01
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Newbie: Finding a Range in 60k numbers and concatenating
Folks, I've been using Access for a week and my first project is to query 60,000 telephone numbers and create ranges when there are gaps in the sequence. For example, TNs 555-123-0000 through 555-123-1000 may be missing a number and so should wind up like this in a new table...- talboyd01
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
