[AccessD] Sum a column in Excel files in a specific folder

Gustav Brock Gustav at cactus.dk
Fri Mar 16 04:39:06 CDT 2007


Hi Ervin

Why not just link the worksheets as tables and read the data with a query?

/gustav

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ervin Brindza
> Sent: Thursday, March 15, 2007 3:21 AM
> To: AccessD at databaseadvisors.com 
> Subject: [AccessD] Sum a column in Excel files in a specific folder
>
> Hi,
> I have a couple of xls files in some folder and need to sum exactly the
> column E in every of them. The number of rows isn't the same in these 
> files.
> Can somebody help me?
> TIA,
> Ervin





More information about the AccessD mailing list