Excel Query fails to include data?
Doing an Excel to Excel query, that is simple enough that the wizard is
adequate. One of the source fields (Price) contains both numeric data, and when such data is not avaiable, a "-". No filters are applied to the price field. In the wizard, preview lists only one item, the "-" unlike the other fields that preview as a complete list. The query correctly returns all the field values except price, which except for the colum label, is all blank. Shouldn't query return the price value even if it is text? Thanks for any suggestions. |
Excel Query fails to include data?
Why am i pretty much unstoppable when it comes to excel? -- excelking54 ------------------------------------------------------------------------ excelking54's Profile: http://www.excelforum.com/member.php...o&userid=28348 View this thread: http://www.excelforum.com/showthread...hreadid=479323 |
All times are GMT +1. The time now is 08:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com