Backing up single tables from a database?

[davidg47]

Is there a way to back-up or export single tables from a SQL Server 2000 database that has literally 100's of tables?

I am building a test application using Access 2003 and only need 3 of the tables from the SQL database to build the test.

Thanks in advance for your help.

 

[FoFa]

Use DTS to copy the individual tables you need.