Re: Create Table in External DB

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

> INTO [MS Access;Database=C:\db99.mdb;].Orders

If you have your database set to 'ANSI' mode,
you get may get SQL like this from the QBE window.

You also need the 'MS Access' clause if you are
using an ADO connection instead of CurrentDB.

In either case '[database].[table]' may be used
instead of '[table] IN [database]'


(david)


<peregenem@xxxxxxxxxxxx> wrote in message
news:1122365771.270161.288190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
>
> 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;
>


.

Relevant Pages

  • Re: Better "Join" vs "Where" clause?
    ... running the SQL directly, in the SQL Server tools, rather than ... WHERE clause has been deprecated, ... AFAIK one cannot perform an outer join in Access without using the explicit ...
    (microsoft.public.access.queries)
  • Thanks
    ... Thanks for "With" clause, ... Why are you formatting data in the back end? ... how to use custom column heading in where clause ... This only works on SQL 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance degradation with view and "left outer join" vs. "from x, outer y"
    ... Turned Every Which Way But Loose", I reminded the attendees that the ANSI SQL '92 parsing rules REQUIRE that filters in the WHERE clause of a query MUST be processed POST-JOIN in order for an RDBMS to be compliant. ... That means that your filter, c.custid = "AB1234", is applied after all rows of the customer table have been LEFT OUTER JOINed to the my_view VIEW with the results stored into a temp table. ... Now if I use the informix extended outer join syntax: ...
    (comp.databases.informix)
  • Re: Report Parameters - no results
    ... Allen Browne - Microsoft MVP. ... I did use the WHERE clause you suggested, and now I'm getting the "wrong ... > What else can I do to try to correct my sql? ... >> the WHERE clause in your query. ...
    (microsoft.public.access.reports)
  • Re: the "having" clause
    ... Start in the FROM clause and build a working table from all of the ... rest of the containing query. ... e) Go to the SELECT clause and construct the expressions in the list. ... As you can see, things happen "all at once" in SQL, not from left to ...
    (microsoft.public.sqlserver.programming)