Re: Using a Select Query to build a MDB table from a Fox table
From: Anders Altberg (x_pragma_at_telia.com)
Date: 05/28/04
- Next message: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Previous message: Gerben Kessen: "Re: Memo Fields as Programs?"
- In reply to: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Next in thread: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Reply: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Reply: RichG: "Re: Using a Select Query to build a MDB table from a Fox table"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 May 2004 10:39:29 +0200
Good morning Eric. At it again <s>,
MS Access has a 'make-table' query with IN <database> clause you can specify
for both source and destination tables. Like this example
... FROM Table IN "" [dBASE IV; DATABASE=C:\DBASE\DATA\SALES;];
... FROM Table IN "C:\DBASE\DATA\SALES" "dBASE IV;"
RichG will have to see about turning an ADO recordset object into a table in
an MDB. As you said the IN <database> clause is specific to Access SQL.
oRecordSet = oConn.Execute("SELECT * FROM <table>")
oRecordSet.Save FileName format
format can adPersistrXML or adPersistADTG
That seems to be theonly one step way of persisting an ADO RecordSet object.
ADO doens't know any specifics of the host environment so it can't turn
around and create Access, VFP, dBase or MySQL tables as desired.
-Anders
"Eric den Doop" <ericdendoop@xspamblockxfoxite.com> wrote in message
news:#ziWfIIREHA.1276@TK2MSFTNGP11.phx.gbl...
> Hello, Anders!
>
> I think Rich wants to send the query result directly into the MDB. Does
> VFP's INTO <destination> support writing into MDB?
> --
> Eric den Doop
> www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8
>
>
- Next message: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Previous message: Gerben Kessen: "Re: Memo Fields as Programs?"
- In reply to: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Next in thread: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Reply: Eric den Doop: "Re: Using a Select Query to build a MDB table from a Fox table"
- Reply: RichG: "Re: Using a Select Query to build a MDB table from a Fox table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
