Get list of odbc drivers vba

broken image

If anyone has any thoughts, I'd love to hear them! My excel will be latest MS365 Home version. However, this isn't happening today! I get a message ' Data source name not found and no default driver specified' Once I have saved the data spreadsheet as a TXT, I open another spreadsheet (I think is a Macro, I have to enable content), I right click A2 and refresh. This TXT file is in a folder which also has an SQL.txt and a Schema configuration setting file (I hope this makes sense to someone!). one sheet for data entry - this is just a normal spreadsheet. I was hoping somebody might be kind enough to point me in the right direction. I reformatted my laptop last month, so haven't used a particular sheet since then, and I am now getting an error message, and I don't know if this is down to the sheets, or an excel update perhaps. I think he must be on holiday, as I haven't had a reply to a query. I have an amazing guy who creates excel sheets for me - sheets I can import into Sage to save manual processing. This is my first post in the forum, and I hope I have selected the correct area to post it! I wanted to ask a quick question, just to get a feel for what might be wrong, with one of my sheets.Ī little background. Morning All! I hope everyone had a good weekend!

broken image