Select data from other DB

[bsn]

Hello NG
I want to select data from another DB, and use this data in currentDB.
I have this SQL in a VBA procedure:
Sql = "SELECT * FROM Firma [MS Access;Database =" & strPath & strFileName &
";]"

It is not working

Any suggestions...

Thanks in advance...

Bjarne

[Anthony England]

"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1...

"Anthony England" <ae******@oops. co.uk> wrote in
news:dt******** **@nwrdmz03.dmz .ncs.ea.ibs-infra.bt.com:

"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1...

"Anthony England" <ae******@oops. co.uk> wrote in
news:dt******** **@nwrdmz02.dmz .ncs.ea.ibs-infra.bt.com:

However, if not, you could also use a simpler form:
SELECT * FROM MyTable IN "C:\Test.md b"

My copies of Access use single quotes for this. Is that an
internationaliz ation issue (I'm on US settings)?

My settings are UK, but I don't believe that matters. I think
either single or double quotes are acceptable to JET but let us
know if it doesn't on your machine.

I also tested selecting Tools>Options>T ables/Queries and choosing
SQL Server Compatible Syntax (ANSI 92) then a query like
SELECT * FROM Contact WHERE Surname LIKE "Smith*"
does not work, I have to use:
SELECT * FROM Contact WHERE Surname LIKE "Smith%"

However, with my tests so far either within saved queries or via
vba, and regardless of settings, either single or double seem to
be fine SELECT * FROM Contact WHERE Surname="Smith"
SELECT * FROM Contact WHERE Surname='Smith'

When you set a source in a different MDB in the query properties
Windows, the QBE writes the SQL with a single quote, so that seems
to suggest to me that the single quote is preferred.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Indeed. And here I would have no objection. But I don't always like the
way my queries are adjusted with the query editor.