-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
For a more accurate placement in the spreadsheet, use Excel's import
data (get data) option (under the Data menu).
If that doesn't work, 'cuz of VBA functions in the Access query, you can
only export an Access query's results to a separate worksheet. Use the
TransferSpreadsheet method. Read the VBA help function on
TransferSpreadsheet Method.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQSpmV4echKqOuFEgEQKPaACg6fWpvP1tBWkZ8IDeR0f2iq g9KssAoJwe
7C5SLGS+kMGBwxq50cQmoPvz
=gZ4Z
-----END PGP SIGNATURE-----
NRB wrote:
Dear friends,
Please help me.I am new to VBA programming in access.I need to open a
query in MS access database and send those data to a existing excel
sheet with the formulas.
Please help me with the code.Can anyone pst a code.I need the data to
be transferred to the existing excel sheet as that sheet contains many
formulas.