MartyConnelly
martyconnelly at shaw.ca
Tue Aug 5 12:36:51 CDT 2003
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 > > >