From Access to MSSQLSERVER
Posted on 1998-05-29
Using VB5, MSSQL server 6,5, DAO
I have mdb database and linked with server exsisting empty table(dbo_cheque)I wanted to move table contents to MSSQL server
sql = "INSERT INTO dbo_cheque SELECT * FROM chequeproper;"
I am getting error message 3070 : MS Jet does not recognize "aaaa"(my mdb fieldname) as a valid field name
I tried to use several field names over there, result the same.
Any help appreciated