Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

exporting access tables

Status
Not open for further replies.
gsc123

gsc123

Programmer
Jan 24, 2008
197
hello, is it possible to create tables in sql server directly from tables in access? Some sort of import?
 
Sort by date Sort by votes
Sure, just right click on some database name in SSMS Object Explorer and choose "Tasks->Import data".

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
 
Upvote 0 Downvote
Sorry where is that, just installed it? server 08
 
Upvote 0 Downvote
also what about each table structure, i,d hate to reinvent the wheel on 30 or so tables
 
Upvote 0 Downvote
Did you right click on your database, Tasks, Import Data and then followed the wizard?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Niki_S
  • Locked
  • Question
Join SQL tables in foxpro
Replies
1
Views
90
pjw001
pjw001
new_to_sql
  • Locked
  • Question
Access SQL Query Error
Replies
5
Views
141
dhookom
dhookom
wsjames
  • Locked
  • Question
Accessing VFP 9.0 Flat Tables
Replies
1
Views
62
Chris Miller
Chris Miller
Auguy
  • Locked
  • Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
67
Auguy
Auguy
jimoo
  • Locked
  • Question
Export Many SQL Tables to Excel
Replies
3
Views
78
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top