I need to import certain columns from Excel, using VB6, into Access.
In the first component of my application, I import text files, and call the "DoCmd.RunCommand acCmdImport" from VB6, as the files I import are fixed width files.
Now I need to import an excel file, but the problem is that I don't need the whole file, I just need some columns. Another issue is that in some excel files, those columns change.
To tackle this, I thought of making text boxes in VB6, in which the user can enter column names, such as R,S,T, in which the data needed is.
So now I need to only import those columns into my access database, using the ADODB connection and recordset.
I haven't done this before, importing only certain columns, so any help will be appreciated !!
Thanks if advance.