I've been all over the internet looking for a resolution on this one, and have not succeeded.
I'm trying to import an Excel file into SQL Server 2000. It fails with the error message that "specified buffer size" is too small.
Here's what I have tried so far:
This article suggests two things: 1)change a registry setting. When I change that on my machine, the setting is not saved with my changes. I've double checked and from what desktop support in my company says, I have full rights to work there- that registry setting just won't allow changes. 2) put the data with the longer text at the top of the file. Tried that, but no effect.
Other articles have suggested exporting the file to *.txt or *.csv, but neither of those are working with SQL Server.
Other articles suggested making certain that SP4 is loaded. I can and did load that on my local machine, but I have no control over the SQL Server box that this database is located on... only my local copy of Enterprise Manager. Again, no effect.
Has anyone ever found a real solution to this bug in SQL Server?
I'm trying to import an Excel file into SQL Server 2000. It fails with the error message that "specified buffer size" is too small.
Here's what I have tried so far:
This article suggests two things: 1)change a registry setting. When I change that on my machine, the setting is not saved with my changes. I've double checked and from what desktop support in my company says, I have full rights to work there- that registry setting just won't allow changes. 2) put the data with the longer text at the top of the file. Tried that, but no effect.
Other articles have suggested exporting the file to *.txt or *.csv, but neither of those are working with SQL Server.
Other articles suggested making certain that SP4 is loaded. I can and did load that on my local machine, but I have no control over the SQL Server box that this database is located on... only my local copy of Enterprise Manager. Again, no effect.
Has anyone ever found a real solution to this bug in SQL Server?