I am connecting to an Excel spreadsheet using an ODBC DSN with the Microsoft Excel Driver.
mDb = New ODBCDatabase
mDB.DataSource = “USBank”
Can I add the file name to the datasource string? I don’t want to hard code it in the DSN because the file name changes each month. I will let the user choose the XL file in my FileOpen method.
Does anyone have an example datasource string for this?
Thanks
you should be able to specify just about everything in code rather than having to set up a dsn
this place has examples for a LOT of dsns that you could then create in xojo using strings and string concatenation
EDIT : this might be useful
https://www.connectionstrings.com/excel/
it took me a while to find the right one for my use (not excel) on here but they do have LOTS of examples
@Norman Palardy thanks for the help.