Re: Insert dataset to another database
- From: "Earl" <brikshoe@xxxxxxxxxxxxxxxxx>
- Date: Wed, 18 Apr 2007 02:33:37 -0400
I don't have an answer to your question, but am fascinated by the dataset
term used in the Subject line of your post. Because that would do what you
need to do, albeit in a different technology.
"JPM" <jpm@xxxxxxxxxxx> wrote in message
news:uUjSA$7eHHA.4136@xxxxxxxxxxxxxxxxxxxxxxx
Hello,
Using VB6/ADO, I'm thinking I can create a recordset and insert it into
another table in a different Jet database, all within the execution of a
single query. But, I can't seem to get it to work, even in an experiment
in Access 2K.
My sql in Access 2K:
SELECT D.lorder as Ord, A.Lorder
FROM [;Database = C:\MyDocuments\Acc2K\Wrk.mdb].OrdersData as A INNER
JOIN [;Database = C:\Access\Work\Sales06.mdb].Detl1 as D On D.Lorder =
a.lorder
WHERE ((D.fg)= 'MXX-NC' Or (D.fg)= 'MXX.NC');
If I've the Sales06 database file open and am working in it I shouldn't
have to specify that database path in the query, I'm theorizing, but
regardless whether I do or don't I get the error "No database specified in
connection string or IN string". I haven't set this up in VB yet, but I
don't see why I should bother if it won't work as an MsAccess query.
I know I mentione the idea of Inserting the result into a table of another
database; I can't even get a select across 2 Jet databases to work. BUT,
I've found examples from people like Doug Steele that apparently work.
'SELECT A.ExpenseID, A.JobID, B.Category
'FROM [;DATABASE=C:\LocumTE\LocumTEData.mdb].[Expense] AS A
' INNER JOIN [;DATABASE=C:\time&expense\time&expensedata.mdb].[Expense]
AS B
' ON A.ExpenseID = B.ExpenseID
Question is, what am I doing wrong with my version of this query?
Should I also post this to an Access newsgroup?
Thanks for any input,
Jim
.
- References:
- Insert dataset to another database
- From: JPM
- Insert dataset to another database
- Prev by Date: accessing the data from a wizard gen xsd dataset table
- Next by Date: Re: accessing the data from a wizard gen xsd dataset table
- Previous by thread: Insert dataset to another database
- Next by thread: Cascading Delete not Cascading
- Index(es):
Relevant Pages
|
