Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2005-12-28 : 14:05:48
|
| When Importing data from Access 2000 to SQL Server 2000 I get an error when the column's data type in Access is Memo if I try to set the column's data type in SQL Server to text or ntext. Here is the error that I am getting. Query-based insertion or updating of BLOB values is not supported.I have tried to change this to a varchar data type but the fields can be very large and some are over the 8000 limit.Short of programmatically adding the data, is there another way to do this in SQL Server? I cannot use the Access upsize wizard.Miranda |
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-28 : 15:24:15
|
| I was just reading the sticky about FAQ's and found my answer. I will insert them programmatically.Miranda |
 |
|
|
|
|
|
Importing data with DTS Import Wizard