Hi all, not sure if this is a MS-Query issue, Access DB, or XL. Anyway, I have an access DB holding text values in the format 123456-12-12. When I do my MS Query, it seems to be taking out the dashes, even though they're stored with dashes in the database table. So when I pull info into XL through MS query there's no dashes, but I'd really like to keep the dashes! Any help is much appreciated.
Check that your Access table field doesn't have a data type of Number with special formatting to make the dashes appear...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks