[AccessD] Importing from Excel/Transpose

Are there always 7 fields?  If so...you could number with a counter...1-7 ( 
I use a function someone on this list showed me called MyAutoCtr for things 
like this...request offline if you need a sample)) then select by number to 
place in the appropriate field?

Hope it helps,

Mark

P.S...I wanted to give credit to who sent me the sample db using this 
function...but there was no documentation or name associated with it.  I 
never thought to look in the properties.  The sample db was created 
by.....(drum rolllll)......Andy Lacey on Wednesday, January 31, 2001 8:00:32 
PM


>From: ewaldt at gdls.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Importing from Excel/Transpose
>Date: Thu, 22 Jun 2006 08:00:01 -0400
>
>I have information coming in from an Excel spreadsheet. There are 7 fields
>in a range, but they are arranged vertically, so Access imports them as 7
>records with a single field. What's the  most efficient manner of copying
>these into a regular Access table? That is, I import them into a temporary
>table, and then want to append them to a "real" one, which requires what in
>Excel would be called transposing.
>
>TIA.
>
>Thomas F. Ewald
>FCS Database Manager
>General Dynamics Land Systems
>(586) 276-1256
>
>
>
>
>
>This is an e-mail from General Dynamics Land Systems. It is for the 
>intended recipient only and may contain confidential and privileged 
>information.  No one else may read, print, store, copy, forward or act in 
>reliance on it or its attachments.  If you are not the intended recipient, 
>please return this message to the sender and delete the message and any 
>attachments from your computer. Your cooperation is appreciated.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com