Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gottabedrew
Starting Member
2 Posts |
 Posted - 2009-06-09 : 13:22:58
|
| I would like to use wildcards in the FROM field.multiple xls files, the from is the tab name within each xls file.I want to use a wild card after export, `'ExportXXXX'`this is an example of what I a starting with, SELECT * FROM `'Export060409 1 $'` any help would be appreciated thank you, Andy |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-10 : 10:32:12
|
| you need to use dynamic SQL.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
gottabedrew
Starting Member
2 Posts |
Posted - 2009-06-11 : 17:17:44
|
Thank youquote:
Originally posted by dinakar
you need to use dynamic SQL.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2009-06-12 : 02:16:43
|
| You can use OpenRowset.Malay |
|
|
|
|
|
|
Wild card in FROM