Import specific columns in Excel into particular Access table column by VBA?

[cutun1217]

hi everybody,
recently, i have to import data from excel file to access table. i did try using wizard but it has some problem so i need to use VBA to import specific column into particular access column. Is this possible to do it?
thanks in advance

 

[Pat Hartman]

The simplest, no-code method, is to link to the spreadsheet and create a query that selects what you want from the spreadsheet and appends it to a table. You may also be able to use an update query but given the lawsuit from last year, maybe not. If you can't use an update query, you can use a make table query and then use that for your update query.

 

[Lukas Pohnan]

Import Excel table into access table

I need to create a command button in an Access form and build VBA code to make the button import a column of data from an Excel file into a table in access.

Could someone please give me an example or tell me the code to do this?