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!

  • 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

Programmer
Jan 24, 2008
197
hello, is it possible to create tables in sql server directly from tables in access? Some sort of import?
 
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.
 
Sorry where is that, just installed it? server 08
 
also what about each table structure, i,d hate to reinvent the wheel on 30 or so tables
 
Did you right click on your database, Tasks, Import Data and then followed the wizard?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top