[AccessD] Excel to Access by clicking cells.

I don't think so Gustav, it's not that easy (:-

The source layout can be compleetly turned around, or even not
structured (matrix based).
Name range is not posible neither cause of layout and to slow (it has to
be done every day).
Linking/importing is out of the question, no way Jose...
The structure of the Excel files will no permit me that.

I must avoid at any cost to change anything to the files because it has
to be done on a 7x7 daily base and just printing and typing it in
manualy would be speedier.

 I don't see any other why than clicking on the appropriate cells making
a multiselect and somehow with the clickorder decide which cell is
what...

You should see the file to fully understand my problem, but the data is
confidential and preparing some dummies would take me half a day...

Erwin



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, January 06, 2004 4:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel to Access by clicking cells.

Hi Erwin

If you can (multi)select cells in a worksheet, you can copy and paste
into an appropriate open select query.

Or you could apply a Named Range to that selecting, save and close, then
link this Named Range as a linked table in Access.

You could even record a macro for each cinema's worksheet to perform
this action ...

/gustav


> We receive on a daily basis (7x7) a lot of excel files with data in it

> from several sources.
> We can not standarise those files for several reasons so we print 
> these files en type the data manualy in Access.
> I was wondering if anyone ever has written a function so you could 
> click the cells with the data and then right-click something and the 
> data is passed to a recordset in Access depending on your multiselect 
> order in Excel.
 
> Importing is not an option because these files change to much and are 
> often to complex (more data in the file then we need).
 
> The data are boxoffice figures from cinema theatres.
> So the data we need as a result looks like this.
 
> Date1 MovieA Tickets Amount
> Date1 MovieB Tickets Amount
> Date1 MovieC Tickets Amount
> Date2 MovieA Tickets Amount
> Date2 MovieC Tickets Amount
> Date2 MovieD Tickets Amount
 
 
> The excel sheets can vary, it can be horizontal, vertical, double 
> vertical double horizontal...
 
> So I believe a multi select would be a solution. I think it will be 
> faster than printing and manual typing.
> I just want some code that put me on the road with this multiselecting

> thing and passing to Access.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com