How to import specific columns from excel file

Whats goin on Fellas?

could anyone help me with a lil issue i'm having today.

i'm trying to create a macro to import ESPECIFIC COLUMNS from an excel file. i was able to import the whole file but not just the columns.
Funny though, eventhough the file i'm trying to import from has a .csv extension, it has an excel file format... but i could save it as and .xlsm extension.
i only want to import columns D, F and K .

here's the code i used. (if u guys find it easier to not use my code, thats fine!!!)

Please Login or Register  to view this content.

Thanx in advance fellas.

Where are you importing the file to?

PS Please add code tags.

This question is in the Excel forum.

If you are importing to Access you should get a text import wizard where you can select the which columns to import/skip.

Create a macro that does the import, convert it to VBA and change as necessary.

Or simply use DoCmd.TransferSpreadsheet to import the entire sheet then execute, with code, a suitable make table query to create a new table with the required columns.