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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to remove part of data in field
Yes, I tried changing it to general but it still did not import the field. What was funny is that all of my other files with the same formatting (text)in that field imported fine. I was able to finally figure this out by using find and replace in Access, but it took a long time to do because...- dassaf
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Need to remove part of data in field
I have a an excel file that I imported into Access. The file was badly formatted and I need to remove some of the data from the second field. For example, one field looks like this:T 30042178901. In this case, I need to remove the T and the spaces just leaving the number. However, not...- dassaf
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
