<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] Copy range of ID's from excel</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>a quick and dirty way:</FONT>
</P>
<P><FONT SIZE=2>A. Have an excel spreadsheet set up as a flat file,ie</FONT>
<BR><FONT SIZE=2>fld1_ID_Key fld2_Descr fld3_Include</FONT>
<BR><FONT SIZE=2>Id1 whatever1 N </FONT>
<BR><FONT SIZE=2>Id2 son of whatever Y</FONT>
<BR><FONT SIZE=2>Id3 why not N</FONT>
</P>
<P><FONT SIZE=2>The field headings should start in cell a1 on the "database" sheet.</FONT>
<BR><FONT SIZE=2>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. </FONT></P>
<P><FONT SIZE=2>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</FONT></P>
<P><FONT SIZE=2>Jim Hale</FONT>
</P>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Sad Der [<A HREF="mailto:accessd666@yahoo.com">mailto:accessd666@yahoo.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, August 01, 2003 9:03 AM</FONT>
<BR><FONT SIZE=2>To: Acces User Group</FONT>
<BR><FONT SIZE=2>Subject: [AccessD] Copy range of ID's from excel</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi group,</FONT>
</P>
<P><FONT SIZE=2>A user wants to select a list of id's and wants to</FONT>
<BR><FONT SIZE=2>paste them into Access. After that the user wants to</FONT>
<BR><FONT SIZE=2>make selections on the id's. </FONT>
</P>
<P><FONT SIZE=2>Question: Which control is the best to use for this</FONT>
<BR><FONT SIZE=2>and why?</FONT>
</P>
<P><FONT SIZE=2>I'm thinking of using a listbox but is it possible to</FONT>
<BR><FONT SIZE=2>select it and paste the range into it. Remember the</FONT>
<BR><FONT SIZE=2>range are completely random!</FONT>
<BR><FONT SIZE=2>Question: How can I paste a range of items in an</FONT>
<BR><FONT SIZE=2>Access object?</FONT>
</P>
<P><FONT SIZE=2>Btw i'm using Access 2000</FONT>
</P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>sander</FONT>
</P>
<BR>
<P><FONT SIZE=2>__________________________________</FONT>
<BR><FONT SIZE=2>Do you Yahoo!?</FONT>
<BR><FONT SIZE=2>Yahoo! SiteBuilder - Free, easy-to-use web site design software</FONT>
<BR><FONT SIZE=2><A HREF="http://sitebuilder.yahoo.com" TARGET="_blank">http://sitebuilder.yahoo.com</A></FONT>
<BR><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>