[AccessD] Importing from Excel/Transpose

Eoin C. Bairéad ebairead at gmail.com
Thu Jun 22 09:43:02 CDT 2006


copy the fields

go somewhere on the sheet with lots of space & click

Do Paste Special, Tick the Transpose box & clock OK

ok ?

On 22/06/06, ewaldt at gdls.com <ewaldt at gdls.com> wrote:
> 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
>
>
>
-- 
-- 
Eoin C. Bairéad
Dublin, Ireland
Áth Cliath, Éire



More information about the AccessD mailing list