Open Database() with csv/txt example?
Does anyone have an Open Database() example for ODBC'ing to a .csv or .txt file? I can get ODBC to work fine with Excel 2007 .xlsx but haven't deduced the text file connection string correctly for opening a .csv file. I'm even referencing the correct "User DSN" name string via Windows ODBC Data Source Administrator. So I'm wondering if I have the wrong "DriverId" shown below? thx... djThis wor...