[AccessD] Importing from Excel/Transpose

Not tried this before so just an idea, couldn't you create a crosstab query in genesis that looks the the temporary table when you have imported the data, then turn that query into a make table query.





Message Received: Jun 22 2006, 01:03 PM
From: ewaldt at gdls.com
To: accessd at databaseadvisors.com
Cc: 
Subject: [AccessD] Importing from Excel/Transpose

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