[AccessD] Copy range of ID's from excel

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030801/1ff8bf6e/attachment-0001.html>