I don't know of any easy way to do it. File / Get External Data / Import
does import the structure and data as you have learned, but I suspect it
doesn't do the indexes because there are index types on SQL Server
(Clustered for example) that Access doesn't understand. You would think it
would at least do the Primary Key! I also tried exporting from SQL Server
to Access using DTS (Data Transformation Services), but that not only didn't
do indexes, it also didn't transform Identity fields into AutoNumber.
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Peter T. Fairchild
Sent: Monday, May 08, 2006 3:51 PM
To: [email protected]
Subject: [ms_access] Indexes on import
John,
How can you import a database from SQL Server or Oracle into Access WITH
the primary keys and indexes? I can import all the data but I've not
been able to get the keys and indexes.
Thanks for your help,
Kind regards
Peter
Peter T. Fairchild
Consultant en Informatique
[EMAIL PROTECTED]
+41-(0)79-715-9155 Portable
+41-(0)21-800-4044 Office
"Form and Function are one" Frank Lloyd Wright 1867 - 1959
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
