Re: Create Table in External DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



david epsom dot com dot au wrote:
> You get sql like this:
>
> SELECT INTO fred IN 'freddd.mdb';
>

Perhaps more like this

SELECT *
INTO [MS Access;Database=C:\db99.mdb;].Orders
FROM Orders;

.