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 Mike Lewis 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
0
0
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

PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
200
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
388
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
250
dhookom
dhookom
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
186
atadbitslow
atadbitslow
TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
187
jedraw
jedraw

Part and Inventory Search

Sponsor

Back
Top