[AccessD] Excel to Access

>
> Of course, this method requires consistent data.

I think you just hit the problem with this method.  I'm going to have to use
specific ranges within the spreadsheet due to the layout.  The spreadsheets
we will be dealing with are not just data stores/calculators - they are used
as informative/formatted forms.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
> Sent: Wednesday, December 07, 2005 11:07 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Excel to Access
>
>
> Hi Reuben
>
> Of course, this method requires consistent data.
>
> /gustav
>
> >>> Gustav at cactus.dk 07-12-2005 16:13:22 >>>
> Hi Reuben
>
> No need to import first.
> Just link the Worksheet or Named Range. Then use a query to
> retrieve the data.
>
> /gustav
>
> >>> reuben at gfconsultants.com 07-12-2005 16:02:27 >>>
> Could someone point me to or provide a nice way to import Excel data in
> Access on a daily basis.
>
> A potential clients uses Excel daily to calculate some stuff about Mutual
> funds.  They then want to send that data to Access at the end of every day
> in order to have a history of the funds.
>
> Thanks.
>
> Reuben Cummings
> GFC, LLC
> 812.523.1017
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>