Click here to Skip to main content
15,891,567 members
Search within:


How to import table from access to sql 2000 with primary key table
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
How to import table from access to sql 2000 with primary key table ?
Posted
Updated 19-Nov-12 21:21pm
v2
Add a Solution
Comments
_Vitor Garcia_ 20-Nov-12 4:37am    
Can you clarify your question ?
You could use Sql Server Import and Export Wizard or DTS (in sql 2000).
ZurdoDev 20-Nov-12 8:04am    
You could also use the publish to SQL option in Access, I think it's called upsizing or something like that. What have you tried?
eyesice 30-Nov-12 8:07am    
i favor @Victor in the recommendation of using Import/Export wizard. it's the most straight forward steps. just remember to set the primary keys on the imported table

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Python MYSQL primary key insert as foreign key in table
create 2 foreign keys based on 2 primary keys of 2 tables on third table
inserting values into foreign key table and primary key table
mulitiple primary keys in a table
how to copy sql table with primary key
Alter table FOREIGN KEY error
Modification of Primary key
insert into table with primary key
Composite Primary Key in Table in Sql server
How to get identity for primary key in sql

Advertise
Privacy
Cookies
Terms of Use
Last Updated 20 Nov 2012
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900