Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query-based insertion or updating of BLOB values not supported

Status
Not open for further replies.
jdclark59

jdclark59

Programmer
Mar 27, 2005
7
US
When trying to import Access tables in SQL 2000 using DTS, I get the above error message. The tables open fine in Access. I went back to old access data that previously imported, and now the same tables show error messages. 3 or 8 tables import properly; 5 get the above error.

Any suggestions?

Thanks for your help

Jack Clark
 
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Execution Slowing on iterative generation of PDF's
Replies
3
Views
609
lameid
lameid
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
237
dhookom
dhookom
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
829
dhookom
dhookom
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
527
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top