Re: SELECT INTO an external database
- From: Alan Forsyth <Not@xxxxxxxx>
- Date: Fri, 31 Aug 2007 08:15:00 -0500
stebain@xxxxxxxxx wrote in news:1188399791.296704.294650
@y42g2000hsy.googlegroups.com:
Is there a way to perform a select into from the currentDb.Tests table
to nDb.Tests?
(IE: "SELECT * INTO nDb.Tests FROM currentDb.Tests")
To answer your quesion:
SELECT * INTO Tests IN 'C:\YourPath\nDB.mdb'FROM Tests;
However, you can't go wrong if you Listen to Larry.
Cheers,
Alan
.
- References:
- SELECT INTO an external database
- From: stebain
- SELECT INTO an external database
- Prev by Date: Re: RE and Cascade Deletes
- Next by Date: Limit to list Property
- Previous by thread: Re: SELECT INTO an external database
- Next by thread: Re: SELECT INTO an external database
- Index(es):
