Import data from Access to Excel containing VB code

[jaclyn.gifford]

Hi!
I am trying to import data from an Access database to an Excel
spreadsheet. I have imported several queries from Access into Excel
already. However the last piece of data that I am wanting to import
into Excel has VB code in the query doing a calculation automatically.
So when I go to Excel to import that piece of data, those queries that
contain the VB code don't even show up as import-able. Is there a way
to import these queries from access into my excel worksheet? I am
using Access 2003 and running on an XP OS. Is it possible to do it in
Excel 2007 if not available in Excel 2003?

Thanks for your help

 

[Arvin Meyer [MVP]]

I did venture that it is possible to export the query from Access to Excel.
The query engine uses the Access Expression Service and the Jet Expression
Service to evaluate the function (VBA code). That wouldn't be running unless
Access is running. While I'm fairly certain you can export from Access, the
only chance there is for an import is to run Access from Excel via
automation and VBA code.

 

[jaclyn.gifford]

I did venture that it is possible to export the query from Access to Excel.
The query engine uses the Access Expression Service and the Jet Expression
Service to evaluate the function (VBA code). That wouldn't be running unless
Access is running. While I'm fairly certain you can export from Access, the
only chance there is for an import is to run Access from Excel via
automation and VBA code.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com







- Show quoted text -

Thank you. Is there a knowledge base or a link that you could provide
that might have a sample of what kind of VB code would be needed in
order to run from Excel?

Thanks for your expertise!

 

[Arvin Meyer [MVP]]

I did venture that it is possible to export the query from Access to
Excel.
The query engine uses the Access Expression Service and the Jet Expression
Service to evaluate the function (VBA code). That wouldn't be running
unless
Access is running. While I'm fairly certain you can export from Access,
the
only chance there is for an import is to run Access from Excel via
automation and VBA code.

Thank you. Is there a knowledge base or a link that you could provide
that might have a sample of what kind of VB code would be needed in
order to run from Excel?

Thanks for your expertise!

I can point you to Access automation articles, but I'm sure that asking in
an Excel newsgroup should be productive.