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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export to Excel values are spread
- Thread starter Pelle55
- Start date
Junior1544
Technical User
this can happen because of spaces, comma's, or ', and " or multiple ' & " in a field... look at your data to see if these are in there at all...
personaly, i tell my users to alwas use a ' in records, and i use just " in my code... just one problem in code, to have a sub string where one might use ', i have to use "" (yes, two right next to each other...) it works for me... and it's just a thought for you...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
personaly, i tell my users to alwas use a ' in records, and i use just " in my code... just one problem in code, to have a sub string where one might use ', i have to use "" (yes, two right next to each other...) it works for me... and it's just a thought for you...
--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
