Lowell,
You SET the @provst variable two times, one following the other. Is this correct?
I supposed it was incorrect and changed the second to @provstr2. Where you write "text" is to put the separator character? If not, where do I put the separator?
I tried to run and got the following message:
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "myFolderFullOfFiles" returned message "Erro não especificado". (Not specified error)
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "myFolderFullOfFiles".
Thanks a lot.
________________
DBA Cabuloso
Lucas Benevides