Import Exel Issue 2

[davjr]

Hi

I recieve my daily work via the internet and have the option to export to Exel.
The issue that I have is that the information that I require is in rows not columns.
ie
ProjectNo, Customer, WorkDescription etc. are setout in rows with the info in the columns. Is it possible to import the spreadsheet and set the rows to fields.

Thanks in advance
Dave

 

[Remou]

In Excel, you can use Paste Special -> Transpose. Would that suit?

 

[davjr]

Thanks for your help REMOU.
I now have that working fine.
How can I run a macro from a command button in Access to transpose and then import my data. I can open Exel with command button set to "Application, run Exel" is there a command line to add that will then run my transpose macro.

Set oApp = CreateObject("Excel.Application")
oApp.Visible = True

Dave

 

[Remou]

The best bet is to record a macro that does exactly what you want and then paste it into Access and prefix the lines with oApp.