Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to upload multiple excel files to the app
i am using this connection string
OLEDB CONNECT32 To [Excel Files;DBQ=$(vFileMG)];
but i am getting an error.
ErrorSource: Microsoft OLE DB Provider for ODBC Drivers, ErrorMsg: [Microsoft][ODBC Driver Manager] Invalid argument value
Could any plz explain me what is the problem .
Thanks,
hi,
can u attach the screen shot for that
by that we come to =know where you exactly struk..
Thank you
Suresh
You do not need any DB connection to load xls files ...
hi
you can use * symbol like ('*.xls')
you can laod all the xls files with out using db connection.
Thank you
you are right but i also need to take multiples sheets from multiple files ..
so nly i am using this ..