ODBC Connection failed

[elakkians]

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,

[Chanty4u]

hi,

can u attach the screen shot for that

by that we come to =know where you exactly struk..

Thank you

Suresh

[alexandros17]

You do not need any DB connection to load xls files ...

[Chanty4u]

hi

you can  use * symbol  like   ('*.xls')

you can laod all the xls files with out using db connection.

Thank you

[elakkians]

[elakkians]

you are right but i also need to take multiples sheets from multiple files ..

so nly i am using this ..