importing acess 2000 tables to sql 2000

D

Dejan

I'm having problem importing acess 2000 tables to sql
2000. I get following message:

Error source: Microsoft JET Database Engine
Error description:Record(s) cannot be read;no read
premissions on (table name)
Contex: Error calling Openrowset on the provider

I can export tables from access to text file and then
import them to sql, but i need all relationships,
indexes,etc. between tables to be transfered too.
Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTS import/Export Wizard Error 0
>> Importing from SQL 6
Problem with table relationships when importing from SQL Server 2005 3
Record(s) cannot be read; no read permission on 'MSysAccessStorage 1
Importing to a Linked Table 0
Importing Data and AUTONUM issues 1
Exporting tables to .sql code 2
Access 97 to SQL 2000 conversion 0

Top