Sep 29, 2008 #2 skrandel MIS Aug 23, 2002 1,378 US You can't. With and XL data provider, you're not running a query. You're importing the whole spreadsheet. If you want it to act like a real query, then you need to build an ODBC data source with the spreadsheet as the "database". Look at http:\\busobj.forumtopics.com I believe there is a topic over there that describes how to do this. Steve Krandel Intuit Upvote 0 Downvote
You can't. With and XL data provider, you're not running a query. You're importing the whole spreadsheet. If you want it to act like a real query, then you need to build an ODBC data source with the spreadsheet as the "database". Look at http:\\busobj.forumtopics.com I believe there is a topic over there that describes how to do this. Steve Krandel Intuit