[AccessD] Copy range of ID's from excel <SOLVED>

Sad Der accessd666 at yahoo.com
Thu Aug 7 08:58:23 CDT 2003


Hi group,

i've got it solved. Using a couple of API's and it
works like a charm. if anybody is interested in how I
did it just let me know.

Regards,

Sander
--- MartyConnelly <martyconnelly at shaw.ca> wrote:
> In Access XP there is a clipboard object that you
> can parse for the 
> data. A bit more difficult in lower levels of
> Access, as you have to use 
> API's see Dev Ashish's site for api methods
> http://www.mvps.org/access
> 
> Sad Der wrote:
> 
> >thnx for the response Jim.
> >
> >Unfortunatly this was not what I meant. A user
> opens
> >an Excel file. (S)He then selects a couple of
> records.
> >EG: user clicks cell A1 and drags the mouse down to
> >A7. So we now have a couple of cells selected in
> blue
> >and with a right mouse click the user selects copy.
> >The selected cells are now 'in' the Clibboard. The
> >user then starts the Access application and needs
> to
> >paste the selected cells, that are still in the
> >Clipboard, into a form.
> >
> >Any idea how to do that?
> >
> >Thnx in advance
> >
> >Regards,
> >
> >Sander
> >--- "Hale, Jim" <jim.hale at fleetpride.com> wrote:
> >  
> >
> >>a quick and dirty way:
> >>
> >>A. Have an excel spreadsheet set up as a flat
> >>file,ie
> >>fld1_ID_Key   fld2_Descr  fld3_Include
> >>Id1           whatever1		N	
> >>Id2           son of whatever Y
> >>Id3           why not         N
> >>
> >>The field headings should start in cell a1 on the
> >>"database" sheet.
> >>Use fld3_include to indicate if the record has
> been
> >>selected. You can let
> >>the user fill this column directly which is the
> >>fastest but least secure way
> >>(do not have blank cells. This could confuse
> Access)
> >>Or you can hide the
> >>"database" sheet and let the user select via list
> >>box the choices and you
> >>update the include field via code. 
> >>
> >>B. link the sheet into an Access database where it
> >>will appear as a table
> >><file><get external data><link tables>. You can
> then
> >>write a query with a
> >>criteria of "Y" for the fld3_include field to
> select
> >>the data and append or
> >>update ("paste into")whatever master table you
> wish.
> >>Alternatively, instead
> >>of linking to the excel spreadsheet you can import
> >>the sheet  with the data
> >>directly into Access as a table <file><get
> external
> >>data><import> and then
> >>manipulate it however you desire. HTH
> >>Jim Hale
> >>
> >>
> >>-----Original Message-----
> >>From: Sad Der [mailto:accessd666 at yahoo.com]
> >>Sent: Friday, August 01, 2003 9:03 AM
> >>To: Acces User Group
> >>Subject: [AccessD] Copy range of ID's from excel
> >>
> >>
> >>Hi group,
> >>
> >>A user wants to select a list of id's and wants to
> >>paste them into Access. After that the user wants
> to
> >>make selections on the id's. 
> >>
> >>Question: Which control is the best to use for
> this
> >>and why?
> >>
> >>I'm thinking of using a listbox but is it possible
> >>to
> >>select it and paste the range into it. Remember
> the
> >>range are completely random!
> >>Question: How can I paste a range of items in an
> >>Access object?
> >>
> >>Btw i'm using Access 2000
> >>
> >>Regards,
> >>
> >>sander
> >>
> >>
> >>__________________________________
> >>Do you Yahoo!?
> >>Yahoo! SiteBuilder - Free, easy-to-use web site
> >>design software
> >>http://sitebuilder.yahoo.com
> >>_______________________________________________
> >>AccessD mailing list
> >>AccessD at databaseadvisors.com
>
>>http://databaseadvisors.com/mailman/listinfo/accessd
> >>Website: http://www.databaseadvisors.com
> >>    
> >>
> >>>_______________________________________________
> >>>      
> >>>
> >>AccessD mailing list
> >>AccessD at databaseadvisors.com
>
>>http://databaseadvisors.com/mailman/listinfo/accessd
> >>Website: http://www.databaseadvisors.com
> >>
> >>    
> >>
> >
> >
> >__________________________________
> >Do you Yahoo!?
> >Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> >http://sitebuilder.yahoo.com
> >_______________________________________________
> >AccessD mailing list
> >AccessD at databaseadvisors.com
>
>http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
> >
> >  
> >
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com


More information about the AccessD mailing list