I see how to use the Open Database statement. I'm trying to build the "DSN=..." string outside the call. I'm trying to use Pick File to get the file, then construct the string to pass to Open Database. Something like
FN = Pick File(); ODB_String = "DSN=Excel Files;DBQ=" || FN; dt = Open Database(ODB_String,"SELECT * FROM ExcelSheet`");
But I keep getting an error. I noticed that the path to the file has forward slashes as returned from Pick File. However the same path has backslashes when I just use
dt = Open Database("Connect Dialog");
That is, in the JSL statement strored in the table, the path has backslashes.