[AccessD] Copy range of ID's from excel

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