Page 1 of 1

Access to MSsql: Error: -2147217900

Posted: Tue Jun 29, 2010 11:18 am
by novoplan
Using MS ACCESS to MSSQL version 3.0.0.138
access 2000, sqlexpress 2008

creating the table is working fine....but transfering data from access to mssql not.
i think the "INSERT INTO" statement isn't correct.

i changed that manually in the dump file.
but i get an error with auto-numbered fields.....

any idea?

sorry for posting here.. but there isn't a board entry for MSSQL

thanks

Re: Access to MSsql: Error: -2147217900

Posted: Wed Jun 30, 2010 5:59 am
by jr
Hi,

Can you send a small sample mdb file that will reproduce the error to info at bullzip dot com?

Regards,
Jacob