importing excel data to access via VBA

[mazemi]

Hi Dears.I want to import some separated columns from an excel file via this codeoCmd.TransferSpreadsheet acImport, 10, "MyTable", "MyExcelFile", True, "A:G, K:K" In fact i don't want to import whole data from my excel file. But it doesn't work. Please help me to set the "Range" parameter in the "TransferSpreadsheet" command.Tanks in advance!

[pbaldy]

I haven't used the range parameter. I'd probably link to the file, then run an append query that selected the desired fields.

[CJ_London]

you can't have multiple ranges - you'll need to use "A:K"

Alternatively reorder your excel file so columns H:J are outside the range you require or have another worksheet to put your 'data for export' into one block

[mazemi]

Tanks Paul and Ajax for your response.As you mentioned It is not possible to use multiple ranges. So I will try to reorder my excel columns and import it in this way. But I have so many excel files for reordering and fixing and this is a challenge!And I also try to use append query too.Tank again.

[pbaldy]

No problem. The link/append query method would let you leave the Excel files as-is.