Hello, I want to read data from a number of excel spreadsheets in a folder. However, I need to create the dsn dynamically through the Java code - anybody knows how to do that ? There should be a cmd line, right ?
Daniel, The DSN typically contains the driver and file name, right? The driver should be known in advance. And the file name, you can pass in at runtime. Concatenate these and you have the DSN. I may be missing the point here though.