[AccessD] Copy range of ID's from excel

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




More information about the AccessD mailing list