Copy recordset to different database

[joxo1]

Hi,

Is there any way of copying a recordset from a table in one database into a table in another database without copying each field value one by one?

Cheers

 

[MakeItSo]

What kind of database?
SQL Server at your disposal?
Perhaps you can create a DTS package and run this from VB?

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]

 

[johnwm]

Go into SQL Books on Line:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

and look up Select Into.

If you work with databases that book should be always to hand!

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts