A way to mapping or redirect file call? thanks

  • Thread starter Thread starter davidw
  • Start date Start date
D

davidw

I have some files, which don't have suffix, but they are csv or txt file.

I want to open them in SQL by using openrowset, but it requires those files
with suffix. How can I overcome that? I am thinking a virtual folder, but I
havn't found a simple sample yet.

Any suggestion?

thanks!
 
Show us your OPENROWSET statement... Are you sure the extension is needed ?
Have you tried "name." ?
 
Back
Top