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 derfloh 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
Joined
Jan 24, 2008
Messages
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 Question
Join SQL tables in foxpro
Replies
1
Views
349
pjw001
pjw001
new_to_sql
  • Locked
  • Question Question
Access SQL Query Error
Replies
5
Views
570
dhookom
dhookom
wsjames
  • Locked
  • Question Question
Accessing VFP 9.0 Flat Tables
Replies
1
Views
290
Chris Miller
Chris Miller
Auguy
  • Locked
  • Question Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
279
Auguy
Auguy
jimoo
  • Locked
  • Question Question
Export Many SQL Tables to Excel
Replies
3
Views
380
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top