> I need to move
> all of the records from the Access table to the SQL Server table.  Is there
> a simple SQL statement to transfer data from one table to another?
 
insert into table1 select * from table2

Get Your Free, Private FarmDance at http://farmer.oracular.com/
_______________________________________________________________________

Free Unlimited Internet Access! Try it now! 
http://www.zdnet.com/downloads/altavista/index.html

_______________________________________________________________________