dbTalk Databases Forums  

Exporting data from SQL 2000 to MS Access 2000.

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


Discuss Exporting data from SQL 2000 to MS Access 2000. in the microsoft.public.sqlserver.dts forum.



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

Default Exporting data from SQL 2000 to MS Access 2000. - 02-13-2004 , 10:33 AM






When creating a dts package to export a sql 2000 db to ms access 2000,
how do i include the constraints and indexes?

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Exporting data from SQL 2000 to MS Access 2000. - 02-13-2004 , 11:14 AM






You can't.

There may be a 3rd party tool out there to do this but not one that I
readily know of or have used.

You may be able to write your own though.

Sorry


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Bob Walton" <walton_bob (AT) hotmail (DOT) com> wrote

Quote:
When creating a dts package to export a sql 2000 db to ms access 2000,
how do i include the constraints and indexes?



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.