Selection data in table

[bbeernaert]

Hello

I would like to have de vba code for selecting a part of a row.

example:
A B C D
1 aef dadf daf adf
2 aef afd daf afe
3

I can withdraw data from excel to put it in a table in access.
I write for every new record a new line.
I would want to easy up this a little bit...




planset As New ADODB.Recordset

planset!MaVM = appXL.Worksheets("sheet1").Range("c47").Value


I would like to select a whole range in excel and than paste it as a part of a row in access with vba code.

Can anyone help me please ???

thx

[NoellaG]

Hi,

if you want a different approach you can link the Excel area to the Access database using a TransferSpreadsheet command like:

DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12Xml, "tblMyExcelData", "strPathFilename", False, "A2:G3"

and then handle the data transfer by action queries

greetings
NG

[bbeernaert]

thx

I m gonna try