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!
Import SQL databse's table to Ms Access 2000
- Thread starter kianang
- Start date
johnnymac43
MIS
In Access 2000:
File - Get External Data - Import
Files of type: ODBC Databases ()
Your SQL server 2000 database will (should) appear under both tabs (File Data Source / Machine Data Source).
Select your database, login to SQL Server, and then select the tables you want and click OK.
HTH
John
File - Get External Data - Import
Files of type: ODBC Databases ()
Your SQL server 2000 database will (should) appear under both tabs (File Data Source / Machine Data Source).
Select your database, login to SQL Server, and then select the tables you want and click OK.
HTH
John
- Status
Similar threads
- Question
- Locked
- Question