Morning All! I hope everyone had a good weekend!
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.
A little background... I have an amazing guy who creates excel sheets for me - sheets I can import into Sage to save manual processing. I think he must be on holiday, as I haven't had a reply to a query. 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 was hoping somebody might be kind enough to point me in the right direction.
The set up is.. one sheet for data entry - this is just a normal spreadsheet. This gets saved as a TXT file. 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!). 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.. and this updates with all the new info.
However, this isn't happening today! I get a message "[microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I am on 64 bit MS Windows 10.0.17763. My excel will be latest MS365 Home version.
If anyone has any thoughts, I'd love to hear them!
Bookmarks