import excel columns

[eugz]

Hi All.
Is it possible to import Excel columns to Access record. It means in Excel I have:
AAA 45.23
BBB 65.63
CCC 15.01
DDD 55.02
EEE 84.31

In Access record should look like:
Name AAA BBB CCC DDD EEE
----------------------------------------------
Comp 45.23 65.63 15.01 55.02 84.31

Where Name will entered in textbox.
I would like to create form with textbox and button which execute that import. If it is possible can somebody display a code how to do it.
Thanks.

 

[ajetrumpet]

highlight the data in excel, push the right click button on your mouse, and check out the "transpose" menu option. That might get the data in the right format for you before import. Just an idea....