Import an Excel column and make it a row in access (Access 2000/xp and excel 200/xp)

Topic

New Reply

I have a column of labels in an excel file (5,000 rows). I want to import into access and use as my header (first row) fields. Is there an ez way to do this? thank you.

Reply | Quote

Replies

The easiest way would be to copy the range and then do a paste special in Excel and select the Transpose option. That will convert the column to a row and you can then import the range into Access without any effort. In the import, tell it the range has column headers and your labels will become field names.

Reply | Quote

Be aware that there is a limit of 255 fields in a table in Access 2000. I don’t know whether XP is different.

Reply | Quote

Hi,

Bad news and good news. No, the limit still there, 255 fields per table. Good code how to transpose at MS site http://support.microsoft.com/support/kb/ar…RCH&SPR=ACC2002

Cheers!
Tim K.

Reply | Quote

In addition, Excel (at least through 2000) is limited to 256 rows, so if you transpose a column with 5000 entries the wheels fall off.

Reply | Quote

I think you mean 256 columns, Wendell.

Reply | Quote

You are so right – there I times when I suspect I have a bad case of dyslexia!

Reply | Quote

What, you get your rows and columns transposed?

Reply | Quote

I wish that was all!!!

Reply | Quote