Forum Discussion
Excel VBA - Reading SQL data | Now you see it, Now you don't
Hello, I'm having the damnedest time trying to figure out what Excel is doing with my data. I have an Excel spreadsheet where I connect to a SQL table using ADO to read data and enter that data into...
I have the same issue. I converted from an Access database (where the same code worked) to an SQL database. The data exists as I am able to query the database using Excel and get the data. The VBA program actually creates this data and posts it to SQL. But the subsequent read back into the recordset has the same symptoms you indicated.
@e have determined the problem. The field(s) in question are defined as NCHAR (variable length). Changing to a static length eliminates the issue. But this seems like a VBA issue.