How to add a wildcard to a bulk insert command? I am useing Bulkinsert to brgin in data. Data is always in the same directry with the same prefix (extr_claim), the suffix changes by adding a date (such as_03292011) to the end, then the .txt extension. There will always be just 1 fine in the directry with the prefix. How and I add something like FROM ' mypath \extr_claim*.txt' to my script?