|
 |
access thread: command to read and ouput an Excel file
Message #1 by <elmerespinosa@y...> on Fri, 20 Jul 2001 02:27:52 +0800
|
|
Hi!
Does anyone here knows the command to read and output an excel file.
Appreciate your help.
Thanks
Elmer L. Espinosa
Message #2 by Jose Fernandez <jose@n...> on Thu, 19 Jul 2001 14:56:27 -0400
|
|
Try a product from softartisans.com call ExcelWriter
Jose
At 02:27 AM 7/20/2001 +0800, you wrote:
>Hi!
>Does anyone here knows the command to read and output an excel file.
>
>Appreciate your help.
>
>Thanks
>
>Elmer L. Espinosa
Message #3 by "Kent Rhodes" <kentrhodes@h...> on Thu, 19 Jul 2001 12:39:04 -0700
|
|
You can either record a macro in excel and paste it into your vba code, or
use a docmd.transferspreadsheet command
-----Original Message-----
From: Espinosa, Elmer L. [mailto:elmerespinosa@y...]
Sent: Thursday, July 19, 2001 11:28 AM
To: Access
Subject: [access] command to read and ouput an Excel file
Hi!
Does anyone here knows the command to read and output an excel file.
Appreciate your help.
Thanks
Elmer L. Espinosa
Message #4 by "John Ruff" <papparuff@c...> on Thu, 19 Jul 2001 18:02:45 -0700
|
|
In VBA,
DoCmd.TransferSpreadsheet acImport, 8, "tblDateType", "c:\my
documents\text.xls", False, ""
DoCmd.TransferSpreadsheet acExport, 8, "tblTest", "c:\my
documents\test.xls", True, ""
Look in help for TransferSpreadsheet for all the parameters
John Ruff - The Eternal Optimist :)
At 02:27 AM 7/20/2001 +0800, you wrote:
>Hi!
>Does anyone here knows the command to read and output an excel file.
>
>Appreciate your help.
>
>Thanks
>
>Elmer L. Espinosa
|
|
|
View Cart
