[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.