Problem with TransferSpreadsheet

[SamMy]

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "2006", fileX,
False, "E6:E6"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "2006", fileX,
False, "F6:F6"

The problem is that data appears in Access table in two rows - when they
should go to one row, in columns. How do I do this?

 

[Chris Marlow]

Hi,

But E6 & F6 are next to each other ... or was you question in general?

Using transferspreadsheet I'd import to 2 temp tables & then insert into the
third 'proper' table using a query. There are better ways (involving firing
up an instance of Excel silently from Access) but it depends how technical
you want to get.

Regards,

Chris.

 

[SamMy]

But E6 & F6 are next to each other ... or was you question in general?

Sorry, I ment that I need cells E6, G7, F14 and so on. Actually I need data
from about 30 cells and I would like to get them in one (Access table) row.

Is there any "easy" way to do this?