Re: Create Table in External DB

> Perhaps, but the syntax I posted is from at least the Jet 3

That is interesting: I have never seen "MS Access;"

If you look at the linked tables, you will see that
the normal connect string is just ";database=c:\db99.mdb",
but that doesn't work in queries.

The SQL I posted is what I get when I drop down the
Query Menu, and select Make Table query.

I was wrong to suggest that your SQL was 'ANSI' SQL.
I don't know what the syntax would be for that, but
I suspect something like:

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\db.xls; Extended
Properties='Excel 8.0;HDR=Yes;IMEX=1'

(david)


<peregenem@xxxxxxxxxxxx> wrote in message
news:1122451515.565204.41350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
>
> david epsom dot com dot au wrote:
>> > 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.
>
> Perhaps, but the syntax I posted is from at least the Jet 3 era i.e.
> not limited to Jet 4 which 'ANSI' mode implies.
>
>> You also need the 'MS Access' clause if you are
>> using an ADO connection instead of CurrentDB.
>
> I use 'MS Access' simply to fully qualify the data source as, erm, Jet
> :)
>


.

Relevant Pages

  • Re: Buggy SQL Syntax for External File Path in Access 2007
    ... Parentheses around the sub-select are turned into square brackets ... AS Alias is Jet SQL's syntax for derived tables. ... One option you might consider is setting your database to use ANSI ... 92 SQL, which will mean that you can use the standard AS Alias ...
    (microsoft.public.access.modulesdaovba)
  • Re: Bitwise And
    ... is saved/flagged as an 'ANSI' mode view or procedure. ... 'ANSI' queries can also (and this ... the SQL is also Jet complient SQL, ...
    (microsoft.public.access.queries)
  • Re: Identischer SQL - Befehl liefert zwei unterschiedliche Werte
    ... portabel ist ausschliesslich die ANSI Syntax. ... Joe Celko's SQL for Smarties. ... Und das ANSI JOIN gehört zum SQL 92 Standard, ...
    (microsoft.public.de.sqlserver)
  • Re: Select * From clause
    ... > Is this incorrect? ... ON" syntax was indeed introduced in ANSI SQL -92. ... the "old syntax" is fully allowed in ANSI SQL-92 and thereafter. ...
    (microsoft.public.sqlserver.programming)
  • Re: Create Table in External DB
    ... david epsom dot com dot au wrote: ... > you get may get SQL like this from the QBE window. ... but the syntax I posted is from at least the Jet 3 era i.e. ... not limited to Jet 4 which 'ANSI' mode implies. ...
    (microsoft.public.access.queries)