dbTalk Databases Forums  

importing tables from access 2000 to sql 2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss importing tables from access 2000 to sql 2000 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dejan
 
Posts: n/a

Default importing tables from access 2000 to sql 2000 - 09-08-2003 , 01:11 PM






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


Reply With Quote
  #2  
Old   
Sue Hoegemeier
 
Posts: n/a

Default Re: importing tables from access 2000 to sql 2000 - 09-08-2003 , 07:24 PM






If you need all relationships, indexes, etc to be transfered
as well, you may want to look at the upsizing wizard.

-Sue

On Mon, 8 Sep 2003 11:11:56 -0700, "Dejan"
<simurdic (AT) hotmail (DOT) com> wrote:

Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.